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.
| Region | One and a half | One thousand |
|---|---|---|
| English (US / UK) | 1.5 | 1,000 |
| Germany, France, Spain, Italy… | 1,5 | 1.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.
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:
#VALUE! errors when a formula tries to calculate with it;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.
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.
#VALUE! or wrong totals.