Number Format Converter (1,234.56 ↔ 1.234,56 ↔ 12,34,567)

About the Number Format Converter (1,234.56 ↔ 1.234,56 ↔ 12,34,567)

Paste numbers written the way any country writes them — 1,234,567.89 in the US, 1.234.567,89 in Germany, 1 234 567,89 in France, 1'234'567.89 in Switzerland, 12,34,567.89 in India, ١٬٢٣٤٬٥٦٧٫٨٩ in Arabic — and get them back in the format you need: another country’s (written by your browser’s copy of the Unicode CLDR data), a plain number for a spreadsheet, a custom format with the separators you choose, or the digits of another script.

The converter works out each number’s decimal mark and digit grouping, sets currency signs and units aside, and keeps every digit exactly — long amounts are never rounded through floating point. When a number could be read two ways (1.234 is one thousand two hundred and thirty-four in Germany and one point two three four in the US), it reads it like the other numbers in the list, or the way the chosen country writes numbers, and flags it. Lists and CSV columns are converted at once, in your browser.

Common uses

• Pasting European amounts (1.234,56) into a spreadsheet set to US format, or the other way round.
• Cleaning a CSV column of prices written with decimal commas before an import.
• Writing an amount the way a client in another country expects, including Indian lakh grouping.
• Turning Arabic-Indic, Persian or Devanagari digits into 0–9, or back.

How a number is read

The last of a dot and a comma in a number is its decimal mark (1.234,56, 1,234.56); the other one groups digits. Spaces, no-break spaces, narrow no-break spaces, thin spaces, apostrophes and underscores only ever group digits. Groups must be thousands (1,234,567) or Indian groups of two after the first three (12,34,567), so a typo such as 1,23,4 is caught rather than misread. Arabic and Persian have their own marks (٫ decimal, ٬ group), which settle the reading. A minus sign, a trailing minus, accounting parentheses, +, scientific notation (1.5e3), currency signs and codes (€, US$, Rs., USD, kr) and % are understood.

Ambiguous numbers

A single dot or comma followed by exactly three digits, with one to three digits before it — 1.234, 12,500 — is either digit grouping or a decimal with three places. The converter reads it like the other numbers in the list when they settle it (a 2.500,75 elsewhere means the dot groups digits), otherwise with the decimal mark of the chosen Country (the one at the top of the page unless you pick another), and flags it with the other reading. Numbers with a leading zero (0.500), with more than three digits before or after the mark, or with both marks are never ambiguous.

Country formats (Unicode CLDR)

Country formats come from your browser’s Intl.NumberFormat, which follows Unicode CLDR (number symbols): 1,234,567.891 in the US, 1.234.567,891 in Germany, Italy, Spain and Brazil, 1 234 567,891 with narrow no-break spaces in France, 12,34,567.891 in India, ١٬٢٣٤٬٥٦٧٫٨٩١ in Egyptian Arabic and ۱٬۲۳۴٬۵۶۷٫۸۹۱ in Persian. Some languages do not group four-digit numbers: Spanish and Polish write 1234, while Spanish writes 12.345 and Polish 12 345. Because browsers update CLDR now and then, a detail such as Switzerland’s apostrophe (’ or ') can differ between browsers.

The chosen country’s own format is English as written there when your browser has it (English for Germany writes 1.234.567,891, English for India 12,34,567.891), otherwise the country’s main language with Western digits: Chrome, for example, has no English data for Brazil, Mexico, Russia or Turkey and would write US English instead, so Brazil gets Brazilian Portuguese (1.234.567,891).

Exact digits and rounding

Numbers stay decimal text from start to end: 12345678901234567890.12 keeps every digit, which a spreadsheet or a calculator working in floating point would not. Decimals: as written keeps each number’s own decimals; a fixed number of places rounds half away from zero (2.345 → 2.35, −2.5 → −3), the way Intl.NumberFormat does. A plain number has no grouping and a dot (or, for spreadsheets set to a comma, a comma) as its decimal mark.

Limitations

• One number per line or per cell: text around a number other than a currency sign, code, unit or percent sign is not read.
• Up to 20,000 numbers at a time. Fractions (1/2), Roman numerals and number words are not read: see the Number to Words tool for words.
• Country formats depend on your browser’s CLDR data; very old browsers may round numbers longer than about 15 digits in that output (the plain and custom outputs never do).

Privacy

Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.