LimitLine

Learn · updated 2026-10-26

49.6, 49,6 or 1,250: How Number Formats Are Read

By Nicholas Williford, Lean Six Sigma Black Belt · About LimitLine

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 pasteCaseLimitLine reads
49.6 47.6 49.9Dots as decimals49.6, 47.6, 49.9
49,6 47,6 49,9Decimal commas49.6, 47.6, 49.9
1,250.5 1,310.2Comma thousands, dot decimals1250.5, 1310.2
1.234,5 1.310,2Dot thousands, comma decimals1234.5, 1310.2
49.6, 47.6, 49.9A comma-separated list49.6, 47.6, 49.9
49,6 mm 47,6 mmUnits after the numbers49.6, 47.6
1,250 1,310Ambiguous: an English-language browser1250, 1310
1,250 1,310Ambiguous: a browser set to German, French and similar1.25, 1.31

The rules behind the table:

Where the Trouble Comes From

Before You Trust the Result

  1. Compare the count: the number of values read should match the number of measurements you pasted.
  2. 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.
  3. If your data is ambiguous, type one value with a clear format (1.25 or 1250) and the whole list follows it.
Try decimal commas in LimitLineOpens 10 readings written with decimal commas on an Individuals chart, so you can see how they're read. Free, nothing to install.

The LimitLine Newsletter

About one email a month: new guides, tool updates and one practical SPC tip. Unsubscribe in one click.

We'll email you once to confirm before anything else is sent. Privacy