Excel European Number Format: Decimals and Separators

How-to basics · Updated November 19, 2026

To use a European-style number format in Excel for Microsoft 365 on Windows, set the decimal and thousands separators under File > Options > Advanced, or format individual cells from the Home tab. A common pattern is 1.234,56, but Europe does not use one universal number format: the punctuation and grouping conventions vary by country and language.

What European number format means

In many countries that use a decimal comma, a comma separates the whole-number part from the fractional part, while a dot or a space groups digits in threes. For example, the value one thousand two hundred thirty-four and fifty-six hundredths might appear as 1.234,56 or 1 234,56. In a format that uses a decimal point, the same value is usually written as 1,234.56.

These conventions are often called number formats or regional formats, but there is no single standard called the European format that applies everywhere. Some countries use a comma for decimals and a dot for grouping; others prefer a space or a nonbreaking space for grouping. The UK and Ireland commonly use a decimal point and comma grouping. The expected style can also depend on the language, document, or organization.

It helps to separate three things that are easy to confuse:

  • The value: the numeric quantity Excel stores, such as 1234.56.
  • The display: the punctuation and number of decimal places Excel shows in a cell.
  • The input text: the characters Excel receives when someone types or imports a value.

Changing the display does not necessarily change the stored value. Conversely, text that looks like a number may not be stored as a number at all, which can affect calculations, sorting, and charts.

How Excel chooses separators

Excel normally follows the regional number settings in Windows. In its advanced options, the Use system separators setting tells Excel to use the decimal and thousands separators supplied by the operating system. If that option is cleared, you can enter separators directly in Excel. This setting applies to the Excel application, not just to one cell, so changing it can affect how numbers appear and are entered across open workbooks.

A workbook can contain values and number formats, but the display may look different on a computer configured for another region. The same underlying value can therefore appear with different punctuation when a colleague opens the file. This is usually a presentation difference, not evidence that the number itself changed. For workbooks shared across countries, make the intended convention clear in headings, instructions, or sample values.

Excel also uses regional conventions when interpreting typed values and formulas. In many decimal-comma setups, formulas use semicolons between function arguments so the comma can remain the decimal mark. Excel adjusts formula syntax to the installed locale; do not assume a formula copied from a different regional setup will use the same separators.

Set separators in Excel for Windows

To set separators for Excel on Windows, follow these steps:

  1. Open File > Options > Advanced.
  2. Under Editing options, find Use system separators.
  3. Leave it selected to follow Windows regional settings. To choose Excel-specific separators instead, clear the checkbox.
  4. When the boxes are enabled, enter the preferred character in Decimal separator and Thousands separator. For a common decimal-comma arrangement, enter a comma for decimals and a dot or space for grouping.
  5. Select OK, then check representative values in the workbook.

For Windows 11, the operating-system region is available under Settings > Time & language > Language & region. The exact regional options can differ by Windows version. Changing the Windows region may affect other applications, so using Excel’s own separator controls can be more convenient when you only need to change Excel’s behavior.

On Excel for Mac, look under Excel > Settings (called Preferences in some versions) and then Advanced for the system-separator setting. The exact labels can vary by release. Excel for the web does not offer the same desktop Options dialog; regional formatting controls may be available under File > Options, depending on the account and interface. If you cannot find a workbook-level setting there, check the browser or Microsoft 365 regional settings and verify the result in the sheet.

Format selected cells without changing all of Excel

If the goal is to show a particular column with a certain number of decimal places, format the cells rather than changing Excel’s general separators. Select the range, open Home > Number, and choose a number style or use the dialog launcher in the Number group. You can also press Ctrl+1 on Windows to open Format Cells. On Mac, use Command+1.

In the Format Cells dialog, choose Number, set the decimal places, and select Use 1000 Separator if that option is appropriate. The exact punctuation shown still depends on regional settings. For instance, setting two decimal places and digit grouping does not guarantee that a cell will show a dot for grouping on every computer; Excel may display the locally configured characters.

Use the Currency or Accounting category when the value is money, and choose the relevant currency symbol rather than treating punctuation as a currency setting. A euro symbol does not by itself determine whether decimals use a comma or whether groups use dots. Also, number formatting changes how a value is displayed, not its mathematical value. Increasing visible decimal places reveals more of the stored value; it does not round that value for later calculations.

Import numbers from CSV and other files

Imported data is a common source of problems because a file may have been created with different regional conventions. A CSV row might contain 1.234,56, while the importing Excel setup expects 1,234.56. Excel may interpret the first value as text, parse it incorrectly, or split fields unexpectedly if the file’s delimiter is also a comma.

For a new import, use Data > From Text/CSV and inspect the preview before loading the data. Check the delimiter, the column boundaries, and whether sample values look like the intended numbers. If the preview or loaded column has been assigned the wrong type, open the file in Power Query and use the column’s type menu or context menu to choose Change Type > Using Locale. Select a number type and the locale that matches the source data, not merely the locale of the computer doing the import.

Some regional CSV files use semicolons between fields so that commas can serve as decimal marks. Do not replace punctuation blindly across an entire file: a dot or comma might be a grouping mark, a decimal mark, a field delimiter, or part of text. Keep an untouched copy of the source file and compare several known values after import. For an existing column that Excel has already stored as text, importing it again with the correct locale is often safer than applying Find and Replace to the whole worksheet.

Recognize text values and other common problems

A cell can look numeric but still contain text. Clues include values aligned to the left by default, a warning indicator, or numbers that do not behave as expected in totals and sorting. Alignment alone is not conclusive because formatting and alignment settings can override Excel’s defaults. Check the cell’s behavior and use a small sample before changing a large dataset.

Common causes include pasting values from a website, opening a CSV with a mismatched locale, or including an apostrophe before a value. Changing a cell from Text to Number after the fact may not convert the existing contents automatically. Depending on the source and Excel version, options such as the warning menu’s conversion command or the Text to Columns wizard can help, but check the result rather than assuming every entry was converted correctly.

  • Digits appear in the wrong places: confirm whether the source uses a comma or dot for decimals and whether grouping marks are present.
  • Values do not calculate: check whether the cells contain numbers or text, and whether spaces or apostrophes are embedded.
  • CSV columns shift: verify the field delimiter in the import preview; decimal commas may coexist with semicolon delimiters.
  • A colleague sees different punctuation: compare regional settings and distinguish a display change from a changed underlying value.

When converting a list, compare several entries with the source and check a total or another known result. A conversion that silently drops a decimal mark can produce plausible-looking but incorrect numbers, so visual inspection of just one row is not enough.

Choosing a format for shared workbooks

Choose the convention that fits the people who will read or enter the data, and state it clearly when ambiguity is possible. For a local team, following the organization’s regional settings is often simplest. For a workbook shared internationally, include an example such as 1 234,56 in an instruction or use a clear column heading. For technical data exchange, agree on the source format and import locale instead of relying on how a number happens to look on one person’s screen.

Be especially careful with identifiers such as product codes, postal codes, and account references. These may contain digits but are not quantities; leading zeros can matter, and arithmetic is not intended. Store such identifiers as text rather than converting them to a numeric format. Dates also have regional ambiguity: a string like 03/04/2026 can mean different dates in different conventions. Import dates with the appropriate locale or use an unambiguous date presentation when sharing them.

For published reports, consider including units and currency codes where needed. A value displayed as 1.234,56 does not reveal whether it represents euros, dollars, or another unit. Consistent number formatting, clear labels, and a note about the convention help prevent readers from mistaking a presentation choice for a different value.

Frequently Asked Questions

How do I make Excel use a decimal comma?
In Windows Excel, open File > Options > Advanced. Clear Use system separators, then set the decimal separator to a comma and choose the grouping separator you want. If you want Excel to follow Windows instead, leave the option selected and change the Windows regional settings.

How do I display 1.234,56 instead of 1,234.56?
Set a decimal-comma regional configuration and use a number format with two decimal places and digit grouping. Excel’s exact displayed punctuation depends on its regional separators, so verify a sample cell after changing the setting. If a value is text, formatting it as a number alone may not convert it.

Why does Excel treat a European number as text?
The characters in the value may not match the locale Excel is using to interpret the input. This often happens when importing or pasting decimal-comma data into a decimal-point setup. Re-import with the source locale, or convert a small test range and confirm the results before applying a method to the full column.

Does changing the number format change the value?
Usually, no. A number format changes the cell’s appearance, such as the separators or visible decimal places; the stored numeric value remains the same. A cell containing text that resembles a number is different, because Excel may not include it in calculations until it is converted to a real number.

Will a workbook keep European separators on another computer?
Not necessarily in the same visible form. Another computer’s regional settings can affect displayed separators, even when the stored value is unchanged. If consistent interpretation matters, document the convention and import text using the correct locale; if consistent presentation matters, check the workbook on the target setup.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.