About the Number Formatter
A long number like 1234567.891 is hard to read without grouping. This tool formats numbers with the correct thousands separators and decimal marks for a chosen locale: the US and UK use a comma and dot, Germany the reverse, France a space and comma, and India a distinctive grouping (12,34,567) where after the first thousand digits group in pairs. Convert a whole column at once, one number per line.
It uses the browser's built-in internationalisation, so the grouping and rounding match what the locale expects. To spell numbers out in words instead, use Number to Words; to strip formatting back to a plain number, remove the separators with Find and Replace.
Grouping is more varied than a comma every three digits. The Indian pattern places the first separator after three digits and then every two, so ten million reads 1,00,00,000, and several European locales swap the roles of the comma and the point entirely. The separators are real Unicode characters as well, and French grouping uses a narrow no-break space rather than a plain one, which looks right on screen but will break a spreadsheet import or a parseFloat that expected plain ASCII. The safe habit is to format for display and keep the raw value for storage and arithmetic. Rounding happens at the number of decimals you choose and follows the locale rules rather than truncating, so a value sitting between two representable doubles may not round the way mental arithmetic expects.
How to use
- Paste numbers, one per line.
- Choose the locale and number of decimals.
- Copy the formatted numbers.
Common questions
- Why is Indian grouping different?
- Indian numbering groups the last three digits, then in pairs: 1,00,000 for a lakh, 1,23,45,678 for a crore-scale number.
- Does it round?
- Yes, to the number of decimals you set, using the locale's rounding.
- Can it add currency symbols?
- This tool adds separators and decimals. For currency wording, use Number to Words with a currency.