Currency Format Converter: Commas and Decimals by Country

PublishedToolGlobal Currency Formatter

Contents
  1. 1. How Currency Formats Are Built, and How They're Classified
  2. 2. Why It Pays to Use ISO 4217 Codes
  3. How to Use the Global Currency Formatter
  4. Wrapping Up
  5. Frequently Asked Questions

When you write an export quote in English for a buyer overseas, when you post the price of an item on a global e-commerce site, or when you tidy up multinational financial data in Excel, there's one spot where mistakes show up surprisingly often. It's how amounts are written.

We tend to assume $1,000.50 — comma for thousands, period for decimals — is just how it's done. But Germany and many other European countries do the exact opposite, writing 1.000,50 €. This guide explains the ISO 4217 international currency standard, the rules for where each country places its currency symbol, and the local comma-and-period conventions from the ground up, in terms of the math and the notation itself.

Summary ① ISO 4217 currency codes: The dollar is USD, the euro is EUR, the yen is JPY, and the won is KRW — three-letter identifiers assigned by the International Organization for Standardization (ISO) that financial systems around the world use in common. ② Local swap of separators: English-speaking countries (the US, the UK) and Korea use [comma , for thousands] [period . for decimals], while continental Europe (Germany, France, Italy) flips them completely and prints [period . for thousands] [comma , for decimals]. ③ Symbol placement: prefix style, with the symbol in front of the number ($100), and suffix style, with a space and the symbol after the number (100 €, 100 ₩), are assigned differently depending on each language region's legal rules. ④ With the Global Currency Formatter, the moment you enter any amount, the standard local formats and thousands/decimal symbols for 13 major world currencies render on screen.

1. How Currency Formats Are Built, and How They're Classified

To prevent trillion-scale disputes caused by misreading an amount in an international financial contract, you need to know the three main variables that define how each culture writes money.

Thousands Separator and Decimal Mark

  • Type A (English-speaking world and Asia):
    • Countries: United States, Korea, Japan, United Kingdom, Canada, Australia, Singapore, and others
    • Format: Comma (,) for thousands, period (.) for decimals.
    • Example: $10,250.75
  • Type B (continental Europe):
    • Countries: Germany, France, Italy, Spain, Brazil, Vietnam, and others
    • Format: Period (.) or a thin space for thousands, comma (,) for decimals.
    • Example: 10.250,75 € or 10 250,75 €
  • Type C (the Swiss special):
    • Countries: Switzerland
    • Format: Keeps the very distinctive accounting convention of using a single quote (') as the thousands separator.
    • Example: CHF 10'250.75

Where the Currency Symbol Goes

  • Prefix: The dollar ($), pound (£), yen/yuan (¥), and similar symbols go directly to the left of the amount with no space.
  • Suffix: The euro (€), krone (kr), Korean won (₩, in global usage), and similar symbols follow the amount with one space in between, which is what national language guidelines call for.

2. Why It Pays to Use ISO 4217 Codes

When a currency symbol breaks because of font compatibility, or when two currencies share the same ¥ symbol — as the yen and the yuan do — and there's a risk of fraud or confusion, business practice is to standardize on the three-letter ISO 4217 currency code, no exceptions.

  • How ISO codes are built: The first two letters come from the country name (ISO 3166-1 alpha-2), and the third letter comes from the currency name's initial.
    • US (United States) + D (Dollar) = USD
    • KR (Korea) + W (Won) = KRW
    • JP (Japan) + Y (Yen) = JPY
  • Example wording for a contract: Instead of complicated printed symbols, standardize on the suffix form — 50,000 KRW, 2,500 USD. Global financial APIs and international buyers can then read the contract amount precisely, with no room for misunderstanding.

How to Use the Global Currency Formatter

If it's a hassle to write regex formulas in Word or Excel every time to handle each country's decimal swap rules and suffix spacing guides, try the dedicated currency formatter.

Global Currency Formatter

Free · Amount formatter for English business documents · Live comparison of currency notation standards across 13 countries

The tool is designed to be simple and straightforward.

  1. Enter an amount: Type the plain number you want to convert (for example, 1250000.75) into the input field.
  2. As soon as you type, the dashboard report automatically renders a grid of 13 major world currency formats — US dollar (USD), euro (EUR), Japanese yen (JPY), Korean won (KRW), British pound (GBP), and more — each laid out in its local standard form.
  3. Next to each currency format, the thousands separator and decimal mark used for that currency are shown as well, so you can check them by eye and copy them straight into a business email or a draft memo.

Wrapping Up

Behind the seemingly trivial difference between a period and a comma lie each country's accounting conventions and linguistic traditions. When you draft the terms of a deal with international buyers and partners, comparing the standard formats in advance with the Global Currency Formatter is one way to cut down on misreadings.

Global Currency Formatter

Free · Amount formatter for English business documents · Live comparison of currency notation standards across 13 countries

Frequently Asked Questions

Why did continental European countries flip commas and periods and start using the comma as the decimal point, the opposite of the US and UK?

No single origin has been confirmed in the literature, but differences in printing and notation habits are the explanation most often cited.

  • The explanation you hear most: With letterpress printing, a period (.) is small and could be hard to see depending on how the impression came out, while a comma (,) was relatively easy to identify. That's one of the reasons given for why continental Europe adopted the comma as the decimal point.
  • Where things stand now: Whatever the exact origin, continental European countries such as Germany and France today conventionally use a comma for decimals and a period (or a space) for thousands, and that has hardened into each country's standard practice.

Is there a way to import won data that uses European decimal notation (periods and commas reversed) into Excel without breaking it, so the formulas still work?

You have to control this using Excel's Text to Columns wizard or by changing the system separators in Options.

  • Fixing an imported local file: When text in the 1.250,50 format downloaded from a European ERP program is treated as text in Excel and SUM and other formulas won't run, select the column, then go to the Data tab ➔ Text to Columns ➔ step 3 of the wizard and click Advanced.
  • Set the separators explicitly: Force the decimal separator field to a comma (,) and the thousands separator field to a period (.), then click Finish. Excel recognizes the European source text and flips it into standard numeric data that a Korean Windows system can read, so your formulas work perfectly again.

This technical guide is based on the ISO 4217 (Codes for the representation of currencies) international standard specification and the Unicode CLDR (Common Locale Data Repository) localization format specification.

This article was adapted from our Korean original. Read the Korean original

Related articles

  1. Holiday Countdown: Observed Holiday Rules and D-Day FormulaLearn how the US, South Korea, Japan, and Germany set observed holidays and floating dates, plus the JavaScript Date formula for a millisecond D-Day countdown.
  2. UK, Germany, Canada Take-Home Pay: Tax Formulas ComparedCalculate take-home pay in the UK (2026/27), Germany (2026), and Ontario, Canada (2026) using official rates. Includes 2027 changes and a free tool.
  3. Time Zone Calculation and DST Formula for Global MeetingsLearn the UTC offset formula, how DST shifts the gap by an hour, and how to find a meeting window that avoids anyone's sleep hours.
  4. Shoe Width Formula: Measure Your Foot and Read D, 2E, 4E CodesMeasure your foot length and width in mm, get your width ratio, and see which letter width (D, 2E, 4E) to order from US, EU, and UK shoe brands.
  5. Best Time to Post by Time Zone: Posting Schedule FormulaHow to convert Korea time to your target market's golden hours, with UTC offset formulas and peak posting windows for Instagram, LinkedIn, X, and TikTok.
  6. Visa-Free Countries by Passport: Rankings and 6-Month RuleSouth Korea's passport ranks joint 2nd with 188 destinations on the Henley index. Learn visa-free, VOA, and eTA differences and the 6-month passport rule.

Related tools