Paste a list, a spreadsheet column, or a paragraph. The tool adds or removes thousands separators in every number and leaves dates, phone numbers, and IDs alone.
This tool runs entirely in your browser. What you enter is never sent anywhere.Your input is never sent anywhere.
DetailsFormat every number in a list or paragraph in one paste
This tool adds or removes thousands separators in many numbers at once. Paste a column from Excel and every number is converted, or paste a paragraph and only the numbers inside it change.
It tries not to touch numbers that are not amounts: dates, phone numbers, ZIP codes, years, and IDs. Number styles include US and UK commas, Indian grouping, European dots with a decimal comma, and spaces.
Two other modes cover common needs. Short form turns 1234567 into 1.23M, and Amount in words writes a number out the way it is written on a check.
Where it saves time
Spreadsheet columns
Copy a column of figures, paste it here, and copy it back with separators. Or strip the commas before you import the data somewhere else.
Reports and articles
Fix inconsistent number formatting across a document in one pass. Years and dates inside the text are left as they are.
Numbers pasted from the web
A figure copied as 1,234,567 can be treated as text in a form or script. Remove the commas first.
Checks and invoices
Write 1234.56 as One thousand two hundred thirty-four and 56/100 for the amount line.
How to convert numbers in 3 steps
- Choose a conversion: Add commas, Remove commas, Short form, or Amount in words.
- Paste your numbers, spreadsheet column, or text into the box.
- Check the result and click Copy result.
Note: If you enter only one number, the tool shows it in every style at once, and each can be copied separately.
What gets converted and what does not
- Numbers that are skipped: dates (2024-09-25), times, phone numbers (555-123-4567), version numbers, IP addresses, numbers that start with 0, numbers attached to letters (ID12345), numbers in URLs, 16-digit card-style numbers, and numbers that follow a label such as ZIP, ID, order, invoice, or account.
- Years: a four-digit number from 1900 to 2099 inside a sentence is treated as a year. A number alone in its cell is treated as an amount. You can turn the year rule off.
- Remove commas: only numbers with correct grouping are changed. Lists such as 1,2,3 keep their commas.
- Decimals: when you add separators, the input should use a point as the decimal mark. Digits after the point are kept exactly.
- Amount in words: it uses American English and works on cells that hold only a number. Negative numbers are not converted.
One number in every style
The number 1234567.89 in each style the tool supports.
| Style | Result | Where it is used |
|---|---|---|
| US, UK | 1,234,567.89 | English-language text, spreadsheets, finance |
| Indian | 12,34,567.89 | Lakh and crore grouping |
| European | 1.234.567,89 | Dots for thousands and a comma for decimals |
| Space | 1 234 567.89 | Space-separated groups |
| Short form | 1.23M | Headlines, charts, dashboards |
| Check style words | One million two hundred thirty-four thousand five hundred sixty-seven and 89/100 | The written amount line on a check |
The same digits can mean different numbers in different styles. 1.234 is one point two three four in the US style and one thousand two hundred thirty-four in the European style. Pick the style that matches your data before you convert.
Thousands separators in spreadsheets, text, and code
Practical points about separators when you move numbers between tools.
Display formats and text are not the same thing
In Excel and Google Sheets, a cell number format can show thousands separators while the value stays a plain number. This tool changes the characters themselves, which is what you need for text, emails, reports, and data that leaves the spreadsheet.
Why commas break imports and scripts
A value such as 1,234,567 is text to many forms, parsers, and databases, and it can fail a numeric check or a calculation. Remove the commas first, then import.
Mass find-and-replace damages text
Deleting every comma in an editor also removes commas from sentences and from lists like 1,2,3. Remove commas in this tool changes only correctly grouped numbers.
Match the number style to your audience
Readers in India expect 12,34,567, and many European readers expect 1.234.567,89. Using the wrong style can change how a number is read, so choose the style that fits the document.
Common number formatting problems
Numbers with commas fail in a form or script
A value pasted as 1,234,567 is read as text by many fields, and the calculation or import fails.
💡 See the solution▼
A find-and-replace added commas to years and phone numbers
A simple replacement can turn 2024 into 2,024 and a phone number into nonsense.
💡 See the solution▼
A long number is easy to misread
10000000 is hard to read at a glance. It could be one million or ten million.
💡 See the solution▼
The wrong convention changes the value
Text that uses 1.234 for one thousand two hundred thirty-four can be read as a decimal number by software that expects a US style.
💡 See the solution▼
Questions about adding and removing commas
Q.How do I add commas to a lot of numbers at once?
A. Paste the numbers into the box, one per line, or paste a column copied from Excel or Google Sheets, and keep Add commas selected. Every number with four or more digits gets thousands separators. Tabs and line breaks stay where they are, so a table keeps its shape.
Q.Can I add commas to numbers inside a paragraph?
A. Yes. Paste the text as it is. A sentence such as We sold 1234567 units becomes We sold 1,234,567 units, and the words stay unchanged. Numbers that are probably not amounts are skipped, and the note under the result tells you how many.
Q.Which numbers does the tool leave alone?
A. Years from 1900 to 2099 inside a sentence (you can turn this off), dates, times, phone numbers, version numbers, IP addresses, numbers that start with 0, and numbers touching letters, such as ID12345 or 5000km. It also skips numbers in URLs, numbers after labels such as ZIP, ID, order, invoice, or account, and 16-digit card-style numbers. A number alone in its own cell is always treated as an amount, including a year like 2024.
Q.How do I remove commas from numbers?
A. Choose Remove commas. Numbers with correct thousands grouping, such as 1,234,567, lose their commas. A list such as 1,2,3 and a number with wrong grouping are left as they are, so ordinary commas in your text are not deleted. Set Numbers are written as to match your style if you use Indian, European, or space grouping.
Q.Can it use Indian number grouping?
A. Yes. Choose 12,34,567.89 (Indian) under Number style. Indian grouping puts the first comma after three digits and then one after every two, so 1234567 becomes 12,34,567 and 100000 becomes 1,00,000.
Q.Can it convert European formats with a decimal comma?
A. Yes, in two directions. Add commas with the European style writes 1234567.89 as 1.234.567,89. Remove commas with the European style turns 1.234.567,89 back into 1234567.89 with a decimal point. When you add separators, the input should use a point for decimals.
Q.What is the short form?
A. It shortens large numbers with K for thousands, M for millions, B for billions, and T for trillions, so 1234567 becomes 1.23M. You choose 0 to 3 decimal places, and trailing zeros are dropped. Numbers below 1,000 stay as they are.
Q.How do I write an amount in words for a check?
A. Choose Amount in words and paste cells or lines that hold only a number. In check style, 1234.56 becomes One thousand two hundred thirty-four and 56/100. Plain style reads the decimals digit by digit. It handles positive amounts up to 15 digits and, in check style, up to two decimal places.
Q.Can I add commas to a CSV file?
A. Not directly. In a CSV file the comma separates columns, so thousands separators would make it impossible to tell the columns apart. Open the CSV in Excel or Google Sheets, copy the column, and paste it here.
Q.Is my data uploaded?
A. No. The conversion runs in your browser with JavaScript, and nothing is sent to a server.
Your feedback
makes this tool better.
Tell us which features you'd like, what should be fixed, or which new tool you'd like to see. An engineer reads every submission and uses it to guide development.