🔢 Add Commas to Numbers (Free Thousands Separator Tool)

What is the Number Formatter?

A thousands separator is a small mark placed every three digits to break a long number into readable groups. The number 1234567 is hard to read, but written as 1,234,567 your eye instantly sees roughly one and a quarter million. The grouping always starts from the right of the whole-number part and works left in groups of three, so the leftmost group can have one, two or three digits. The fractional part after the decimal mark is never grouped this way. This tool automates the whole job for one number or a long list, so you do not have to count digits and place commas by hand.

Different regions use different marks, which is the main source of confusion. The United States, the United Kingdom and most English-speaking countries use a comma for thousands and a point for the decimal, so 'one thousand two hundred and thirty four, and a half' is written 1,234.5. Much of continental Europe swaps them, writing 1.234,5 with a period for thousands and a comma for the decimal. Others, including the SI metric standard and countries like France and Sweden, use a thin space (1 234,5), and Switzerland traditionally uses an apostrophe (1'234.5). This tool lets you pick the grouping character and the decimal mark independently so you can match any of these conventions.

Writing style guides also have rules about when to use a comma at all. The Associated Press Stylebook and the Chicago Manual of Style add a comma to any whole number of four or more digits, so 1,270 and 5,255 take a comma. The important exceptions are years (2026, not 2,026), page numbers (page 1535), street addresses (5255 Ocean View Drive), and most identifiers like phone numbers, serial numbers and zip codes. Scientific and engineering writing often drops the comma in four-digit numbers and uses a thin space instead of a comma in larger ones. When you paste a list into this tool you stay in control of the grouping, so you can follow whichever house style applies.

The formatting is purely cosmetic: it changes how a number looks, not its value. That matters when you move numbers between tools. A spreadsheet, programming language or database usually wants a plain number with no grouping (and a point as the decimal), so a value displayed as 1,234.50 must be stripped back to 1234.50 before it will parse. The strip mode here does exactly that, removing commas, spaces, periods and apostrophes used as group marks while preserving the decimal portion exactly as entered, so you can round-trip numbers between human-friendly and machine-friendly forms.

Under the hood, every spreadsheet and programming language does this with a built-in formatter rather than manual string surgery. Excel and Google Sheets apply a number format like #,##0 (or the TEXT function, =TEXT(A1,"#,##0.00")) so the cell keeps its true numeric value while displaying commas. JavaScript uses (1234567).toLocaleString() or the Intl.NumberFormat API, and Python uses the format mini-language, f"{1234567:,}", to get 1,234,567. This tool gives you the same result without writing any code, which is handy when you just need formatted text to drop into a document, email, caption or slide.

Why bother at all? Readability and accuracy. Unseparated numbers like 100000000 invite misreading by an order of magnitude, and a single misplaced zero in a financial figure or a report can be costly. Grouping digits into threes lets a reader sound out the scale (thousand, million, billion) at a glance, reduces transcription errors, and makes tables of figures line up cleanly. That is why almost every newspaper, annual report, invoice and dashboard formats large numbers, and why doing it consistently across a document looks professional.

When to use it

• Formatting figures in a report, invoice or slide so large amounts like 1,250,000 are instantly readable.
• Cleaning a column of numbers that already contain commas so they can be pasted into a spreadsheet or imported as plain values.
• Switching a list between US style (1,234.56) and European style (1.234,56) for an international document.
• Standardising prices, populations or statistics to a fixed number of decimal places before publishing.
• Preparing numbers for code, JSON or a CSV where grouping characters would break parsing.
• Adding commas to a long list of values at once instead of formatting each number by hand in a document.

How to use the Number Formatter

1. Enter your numbers in the box, either a single value or one number per line.
2. Pick Add separators to format, or Strip separators to remove them.
3. Choose the thousands separator (comma, space, period or apostrophe) and the decimal mark.
4. Optionally set a fixed number of decimal places, the tool rounds for you.
5. Read the formatted list in the result box and use Copy to grab all of it.

Formula & method

Worked examples

How the same value is written in different regional conventions

Grouping examples by number size (comma style)

Add commas in common tools (1234567 to 1,234,567)

Common mistakes to avoid

• Mixing up the thousands and decimal marks. In the US a comma groups thousands and a point is the decimal, but in much of Europe it is the opposite. Reading 1.234 as one and a bit when it means one thousand two hundred and thirty four (or the reverse) causes real errors. Always confirm which convention a number uses before formatting or stripping it.
• Leaving commas in numbers meant for a spreadsheet or code. A value like 1,234.50 is text to most software because of the comma. Pasting it into a spreadsheet cell or a program can break the math or import it as a string. Use strip mode to get the plain 1234.5 first.
• Grouping the digits after the decimal point. Thousands separators apply only to the whole-number part. The fractional digits are never split into groups of three, so 0.123456 stays as 0.123456, not 0.123,456.
• Adding commas to years, addresses or identifiers. Style guides exclude years (2026, not 2,026), page numbers, street addresses, zip codes, phone numbers and serial numbers from comma grouping. Commas are for quantities, not labels, so do not format an ID just because it is long.
• Assuming formatting changes the value. Adding separators is purely visual. 1,000 and 1000 are the same quantity. The only step that can change the value here is choosing fixed decimal places, which rounds the number.
• Hard-coding commas into a spreadsheet cell. Typing 1,234 directly into a cell can turn it into text or split it across columns on import. In Excel and Sheets, keep the real number and apply a number format (or TEXT) instead, so the value still calculates.

Glossary

Thousands separator

A mark (comma, space, period or apostrophe) placed every three digits in the whole-number part to make a long number easier to read.

Decimal mark

The symbol that separates the whole part of a number from its fractional part, a point in US style and a comma in much of Europe.

Digit grouping

The practice of breaking the integer part of a number into blocks of three digits, counting from the right.

Strip

Removing all grouping separators from a number so it becomes a plain value ready for software or further calculation.

Rounding

Shortening a number to a chosen number of decimal places, adjusting the last kept digit up or down based on the digit that follows.

Integer part

The whole-number portion of a value to the left of the decimal mark, the only part that gets grouped into thousands.

Fractional part

The digits to the right of the decimal mark, which represent a value less than one and are never grouped.

Locale

A regional setting that determines which thousands and decimal marks software uses, such as en-US for 1,234.56 or de-DE for 1.234,56.

Frequently asked questions