Excel Decimal Comma: Change Number Separators

How-to basics · Updated November 19, 2026

To show decimal commas in Excel for Microsoft 365 on Windows, go to File > Options > Advanced, clear Use system separators, set Decimal separator to a comma and Thousands separator to a period, then select OK. This changes how Excel displays and interprets number separators; it does not change the values already stored in your cells.

Why Excel uses a decimal comma or point

Excel’s decimal and thousands separators reflect regional conventions. In many countries, a comma marks the decimal part and a period separates groups of thousands: 1.234,56. In other regions, the same number is written 1,234.56. These are two ways to display the same numeric value, not two different calculations.

Excel normally follows the separators supplied by your computer’s regional settings. That is why a workbook created on one computer may look different on another, even when both copies contain the same numbers. A cell’s underlying value is stored as a number; the punctuation you see is part of how Excel displays or interprets it.

For example, if a cell contains the numeric value 1234.56, it can display as 1.234,56 under comma-decimal conventions or as 1,234.56 under point-decimal conventions. Changing the separators does not multiply or divide the value by 100. That distinction matters when checking totals or sharing a workbook: a changed display is not necessarily a changed calculation.

Change the separators in Excel for Windows

In Excel for Microsoft 365 on Windows, the separator controls are in Excel Options. Follow these steps:

  1. Open Excel and select File > Options.
  2. Select Advanced in the left-hand panel.
  3. Under Editing options, clear the checkbox labeled Use system separators.
  4. Enter a comma in Decimal separator.
  5. Enter a period in Thousands separator, if that is the convention you want.
  6. Select OK to apply the change.

Afterward, a number formatted with two decimal places and a thousands separator should appear in the style 1.234,56. The setting affects Excel’s interpretation of separators when you enter numbers as well as the way it displays them. For example, with a comma configured as the decimal separator, typing 12,5 is treated as the number twelve and a half.

If you want Excel to return to your computer’s regional conventions, go back to the same Advanced settings and select Use system separators. Excel then uses the decimal and thousands symbols provided by Windows. You do not have to reinstall Office or change the Windows display language just to use this Excel option.

Set decimal places for selected cells

Changing separators controls which punctuation Excel uses; it does not decide how many decimal places a cell displays. To control the number of displayed places, select the cells, press Ctrl+1 to open Format Cells, and choose the Number category. Set Decimal places to the amount you need, optionally enable Use 1000 Separator, and select OK. The punctuation will follow the separator settings currently in effect.

For instance, if A1 contains 12.5 as a numeric value and you set the number format to show two decimal places, it can display as 12,50 when comma decimals are active. The extra zero is part of the display format. It does not mean the cell’s value has been changed to a different quantity.

On Windows, Ctrl+1 opens Format Cells. On a Mac, use Command+1. In Excel for Mac, separator controls are in Excel > Settings (called Preferences in some versions) > Advanced; look under Editing options for Use system separators. The names and placement can vary slightly between Mac builds, but the setting serves the same purpose. Excel for the web does not provide the same full desktop Options dialog, so use the desktop app when you need to change its separator controls.

Know whether the setting applies to one workbook

The Use system separators option is an Excel application setting, not a number format saved only in the active workbook. When you change it, other workbooks open in that Excel installation can display and interpret separators differently too. This can surprise people who switch between files prepared for different regions.

If you share a workbook, the recipient’s Excel settings may cause numeric values to appear with different punctuation. Usually that is expected: the value remains numeric, and the recipient’s locale determines the display. If matching punctuation is essential for a report, consider exporting a copy to PDF after checking its appearance, or provide clear instructions about the required regional settings. Do not assume that changing a cell’s number format alone will permanently override every recipient’s application settings.

There is an important trade-off when you need two regional conventions at once. You can change the Excel separators for work in one convention, but that is not a convenient per-workbook switch. One workaround is to create a text version of a value for a specific report, but text does not behave like a number in arithmetic, sorting, or charting. Keep the original numeric data if you use text for presentation.

Existing numeric values and imported text are different

A separator change affects existing numeric cells’ display, but it does not automatically turn text into numbers. If imported data looks like 1.234,56 but Excel treats it as text, changing the decimal separator may leave it aligned as text and unavailable to ordinary calculations. A quick clue is that a value may remain left-aligned when the column uses General formatting, although alignment can be customized and is not a definitive test.

When importing a delimited text file in desktop Excel, use the import options to identify the source number conventions rather than relying on guesswork. In the Text Import Wizard, the Advanced options let you specify decimal and thousands separators for the imported data. In Power Query, set the column’s data type using the appropriate locale when the source uses a different regional convention. The exact interface can depend on how you opened the file and on the Excel build.

For a small amount of text data, you can also use Find and Replace carefully, but replacing punctuation across a whole sheet can damage dates, identifiers, or values where the same character has another role. Make a copy first, select only the intended column, and confirm that the resulting cells are numeric before using them in calculations. A comma-to-period replacement is not a safe universal conversion rule.

How separators affect typing and formulas

When you type a number directly into a cell, Excel uses the active decimal separator to decide where its fractional part begins. With comma decimals, 3,75 represents three and three quarters. If the setting is wrong for the data you are entering, a value may be interpreted unexpectedly or stored as text. Check a few representative entries after changing settings, especially when pasting data from another program.

Decimal punctuation is separate from the character Excel uses between function arguments. In many comma-decimal regional configurations, formulas use semicolons between arguments, because a comma is already serving as the decimal mark. The argument separator is influenced by regional and Excel settings; do not change commas in formulas blindly. When editing a formula, use the separator Excel accepts in that installation.

A formula’s result can remain the same while its displayed number changes. For example, a calculation returning a numeric result of 7.5 can display as 7,5 in a comma-decimal setup. If Excel shows a formula error after a settings change, check the formula’s argument separators and whether any typed numeric constants use the active decimal mark. The punctuation change alone does not require rewriting every formula in a workbook.

Common problems and practical checks

  • The number still has a period. Confirm that Use system separators is unchecked, that Decimal separator contains a comma, and that the cell is not displaying text rather than a numeric value.
  • The thousands mark is unexpected. Check the separate Thousands separator field. A decimal comma does not automatically mean you want a period for grouping; choose the convention required by your data.
  • Values appear as text. Changing display settings will not convert text. Reimport with the correct locale or convert only the affected data after making a backup.
  • Another workbook changes too. This is expected because the separator option applies to Excel, not just one file. Restore Use system separators when you want Excel to follow Windows regional settings again.
  • Formulas stop parsing. Check whether the formula argument separator should be a semicolon in your configuration. Also verify decimal punctuation in any numbers typed directly into formulas.

Before distributing a workbook, test a few key values, formulas, and totals on the computer that will be used to present it. If a workbook contains imported financial or scientific data, compare a known value with the source. This catches cases where text was mistaken for a number or a source convention was misread; it is more reliable than judging the punctuation alone.

Choose the right approach for your task

Use the Excel separator setting when you want to work consistently with comma decimals across the application. Use Format Cells when the issue is the number of decimal places or whether to show grouping marks. Use import locale options when the source file uses a different convention and its values arrive as text or are interpreted incorrectly. These approaches solve different problems, so changing all three settings at once can make it harder to identify what caused a result.

If you only need a comma in a document or a fixed-width export, you may need a presentation-specific output rather than a change to the underlying data. A PDF preserves the appearance for reading, while a delimited text file can be interpreted differently by different applications and regional settings. For data intended for further analysis, retain real numeric cells and document the expected locale instead of turning every value into text.

Frequently Asked Questions

How do I change decimal point to comma in Excel?
On Windows, open File > Options > Advanced, clear Use system separators, and set Decimal separator to a comma. Set the thousands separator separately, then select OK.

Will changing the decimal separator change my numbers?
No, changing the display separator does not alter numeric values already stored in cells. It can affect how newly typed or imported entries are interpreted, so check data from sources that use a different convention.

Can I change the decimal separator for just one workbook?
The Use system separators option is an Excel application setting rather than a workbook-only setting. It can affect other open workbooks in that Excel installation.

Why does Excel still treat my comma-decimal value as text?
The cell may contain text imported from another source. Number-format changes do not convert text into numeric values; reimport or convert the data using the correct decimal and thousands separators.

Does a comma decimal mean formulas need semicolons?
Often, Excel installations using comma decimals also use semicolons between formula arguments, but regional settings determine the accepted separator. Use the character Excel recognizes in your formula bar rather than replacing punctuation indiscriminately.

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.