Learn · updated 2026-10-26
49.6, 49,6 or 1,250: How Number Formats Are Read
A decimal separator is the mark between the whole number and its fraction: a dot in 49.6 (US, UK) or a comma in 49,6 (most of Europe and Latin America); the other mark is often used to group thousands.
Half the world writes forty-nine and six tenths as 49.6 and the other half as 49,6. Thousands are written 1,250 in one country and 1.250 in the next. When measurements are pasted from a spreadsheet, a PDF or an email, a tool has to decide which convention each number uses. A wrong guess doesn't fail loudly: it quietly turns 1.250 into 1250 and wrecks the mean, the limits and the Cpk.
How LimitLine Reads a Pasted List
It looks at all the numbers together, not one at a time, because the other numbers usually settle the question. Every row below was run through the app's own reader (readNumbers in the published code) when this page was built.
| You paste | Case | LimitLine reads |
|---|---|---|
49.6 47.6 49.9 | Dots as decimals | 49.6, 47.6, 49.9 |
49,6 47,6 49,9 | Decimal commas | 49.6, 47.6, 49.9 |
1,250.5 1,310.2 | Comma thousands, dot decimals | 1250.5, 1310.2 |
1.234,5 1.310,2 | Dot thousands, comma decimals | 1234.5, 1310.2 |
49.6, 47.6, 49.9 | A comma-separated list | 49.6, 47.6, 49.9 |
49,6 mm 47,6 mm | Units after the numbers | 49.6, 47.6 |
1,250 1,310 | Ambiguous: an English-language browser | 1250, 1310 |
1,250 1,310 | Ambiguous: a browser set to German, French and similar | 1.25, 1.31 |
The rules behind the table:
- One clear number settles the rest. If any value is unmistakably written with dot decimals (49.6, 1,250.5) or with dot thousands and a comma decimal (1.234,5), the whole list is read that way.
- A comma that can only be a decimal (49,6 or 0,125) means decimal commas.
- Only when every number is like 1,250 is the list truly ambiguous. Then LimitLine follows your browser's language and tells you, next to the result, how it read them.
- Units are dropped and reported (mm, µm, %, °C), and anything that isn't a number is listed as skipped, never silently turned into 0.
Where the Trouble Comes From
- CSV files. In countries that use decimal commas, spreadsheets usually save CSV files with semicolons between the columns, because the comma is taken. A tool that assumes commas between columns splits 49,6 into 49 and 6.
- Copying from a spreadsheet copies the numbers as they are displayed, in your computer's regional format, not the full stored value. Check that enough decimals are shown before you copy.
- Spec limits on their own have no neighbours to learn from. LimitLine reads a lone 1,250 in a spec box as a thousands separator when your data are in the hundreds or more, and as a decimal comma otherwise.
Before You Trust the Result
- Compare the count: the number of values read should match the number of measurements you pasted.
- Glance at the mean and the range. A thousands-or-decimals mix-up moves them by a factor of a thousand, which is obvious once you look.
- If your data is ambiguous, type one value with a clear format (1.25 or 1250) and the whole list follows it.
The LimitLine Newsletter
About one email a month: new guides, tool updates and one practical SPC tip. Unsubscribe in one click.