Home › Excel guides › Decimal separators in Excel: why 1,000 means two different things

Decimal separators in Excel: why 1,000 means two different things

How regional decimal and thousands separators interact with formulas and CSV files — and how to avoid numbers being read incorrectly.

Type 1,000 into Excel and, depending on where your copy of Excel was set up, it means either "one thousand" or "one point zero". The decimal separator — a point in some countries, a comma in others — is one of the most common reasons numbers and formulas go wrong when files cross borders.

Point vs comma

RegionOne and a halfOne thousand
English (US / UK)1.51,000
Germany, France, Spain, Italy…1,51.000

The two systems are mirror images: what one uses for the decimal, the other uses for grouping thousands. So 1,000 is a thousand in English and one in German.

Why it breaks formulas

The decimal separator is tied to the argument separator. Comma-decimal regions can't also use the comma between arguments, so they use a semicolon. That is why moving a formula between regions often needs two fixes at once.

The bigger problem is numbers arriving as text. If a value like 1,5 lands in English Excel — often via a CSV import — Excel may not recognise it as a number. You then get:

How to fix mismatched decimals

Change Excel's decimal setting

On Windows: Control Panel → Region → Additional settings, then set the decimal symbol and digit-grouping symbol. On Excel's own options you can override the system separators under File → Options → Advanced → Use system separators.

Clean imported numbers

If a column came in as text with the wrong decimal, use Find & Replace or Data → Text to Columns to convert commas to points (or the reverse), then confirm the column is right-aligned — Excel's sign that it now sees real numbers.

Key takeaways

← All Excel guides

Copied to clipboard