Before changing the format
A decimal separator marks the fractional part of a number. A grouping separator divides larger numbers into groups. For example, these can both represent the same value:
1,234.56uses a decimal point and a comma for grouping.1.234,56uses a decimal comma and a point for grouping.
Choose the convention required for your work rather than treating one as universally correct. Keep the decimal and grouping characters distinct so that a value is not ambiguous.
Before you start:
- Save open work. You may need to close and reopen an application before it picks up the change.
- Note your current settings. Record the selected regional format, decimal symbol and digit-grouping symbol so you can restore them.
- Check whether the issue affects one app or several. If it is confined to Excel, the app-specific procedure below may be all you need.
- Be careful with existing data. A display-setting change is not a safe way to repair numbers that were already imported or saved as text with the wrong interpretation. Keep the original file and check important values before saving changes.
The Windows steps below apply to Windows 11 and Windows 10. Microsoft ended regular support for Windows 10 on October 14, 2025; eligible devices may receive security updates through an Extended Security Updates program.
Open the regional number settings
The quickest route works on both Windows versions:
- Press Windows key + R.
- Type
intl.cpland press Enter. - In the Region window, select the Formats tab.
- Select Additional settings.
- In Customize Format, select the Numbers tab.
Leave this window open and continue to Set the decimal and grouping symbols below.
If you prefer to navigate through Settings, use the path for your version instead.
Windows 11 Settings path
- Press Windows key + I to open Settings.
- Select Time & language > Language & region.
- Under Regional format, check the selected format. It controls the default conventions for dates, times, numbers and currency in apps that use it.
- Under Related settings, select Administrative language settings.
- In the Region window, select Formats > Additional settings, then select the Numbers tab.
Windows 10 Settings path
- Press Windows key + I to open Settings.
- Select Time & Language > Region.
- Under Regional format, check the selected format.
- Under Related settings, select Additional date, time, & regional settings.
- In the Control Panel window, select Change date, time, or number formats.
- In the Region window, select Formats > Additional settings, then select the Numbers tab.
If you cannot find the Settings link, use the intl.cpl shortcut above to open the same classic Region window.
Set the decimal and grouping symbols
Before applying the change: Windows regional settings can affect number formatting in multiple apps, not just the one where you noticed the problem. If you exchange spreadsheets or text files with other people or systems, check a small sample afterward. Changing the overall regional format can also change date, time and currency conventions; changing the individual number symbols is more targeted.
- On the Numbers tab, find Decimal symbol. Select
.for a decimal point or,for a decimal comma. - Find Digit grouping symbol. Choose a different character from the decimal symbol. For example:
- For
1,234.56, use decimal symbol.and digit-grouping symbol,. - For
1.234,56, use decimal symbol,and digit-grouping symbol.. - Review the number examples shown in the dialog. They should reflect the convention you chose.
- Select OK to close Customize Format, then OK again to close Region.
- Close and reopen the affected app. For Access, Microsoft notes that you may need to close and reopen the database for regional changes to take effect.
You do not need to change the List separator to fix a decimal symbol. A list separator has a different job: it can determine how items or fields are separated. Leave it alone unless you have identified a separate need to change it.
If the entire regional format is wrong—not just the decimal symbol—you can select a different Regional format in the Windows Settings path above. Check the resulting date, time and currency formats as well as numbers, because the change is broader than choosing a single symbol.
Verify the change in Windows and the affected app
First, press Windows key + R, run intl.cpl, and return to Formats > Additional settings > Numbers. Confirm that Decimal symbol and Digit grouping symbol still show your choices. This verifies the saved Windows settings, even if a particular application formats numbers differently.
Then test the application that prompted the change. Use a new, disposable document or worksheet rather than important data:
- Enter a simple fractional value using your chosen decimal character:
1.5for a point or1,5for a comma. - Check whether the app accepts and displays the value as one and a half.
- If the app can perform calculations, multiply the value by
2. The result should be3. If it reports an error or the result is not three, do not assume the original entry was interpreted correctly. - Test a larger value as well if grouping matters to your work. Check that the displayed grouping and decimal marks are in the expected positions.
A formatting change controls how participating apps present or interpret new input; it does not guarantee that an existing text entry, imported field or incorrectly interpreted value has been repaired. Compare important figures against the original source, especially before exporting or saving over a file.
Check or change Excel’s separators
Excel for Windows normally uses the Windows separators, but its own setting can override them. This is useful when Excel needs a different convention from the rest of the PC—or when Windows is correct but Excel is not.
To make Excel follow Windows:
- Open Excel and select File > Options.
- Select Advanced.
- Under Editing options, find Use system separators.
- Select the checkbox if it is cleared, then select OK.
- Test a fresh value in a blank workbook using the verification steps above.
To give Excel its own separators instead:
- Select File > Options > Advanced.
- Under Editing options, clear Use system separators.
- Enter the desired characters in Decimal separator and Thousands separator.
- Select OK, then test a new value in a blank workbook.
To undo the Excel-only override, return to the same screen, select Use system separators, and select OK. Excel will then use the separators defined in Windows again.
Be cautious when exporting CSV files after changing Excel’s separators. Microsoft notes that choosing a decimal comma in Excel can also make Excel use a semicolon as the list separator when saving a CSV. Check the resulting file against the requirements of the app or person receiving it.
For another application, look in its preferences for language, region, locale or number-format settings. Some applications provide their own controls; their names and behavior depend on the app. If there is no such option, consult the app’s documentation before assuming it follows Windows.
Troubleshoot numbers that still look wrong
Windows shows the right symbols, but one app does not
Reopen the app and check its own regional or separator settings. In Excel, check Use system separators as described above. Also check whether the number is displayed using an application-specific or document-specific format.
If the problem persists only in one application, record the Windows symbols, the app’s separator settings and a small example of the input and output. Give those details to the app’s support team or your organization’s IT administrator. Avoid changing unrelated system language or administrative settings as a first attempt.
A spreadsheet shows too few decimal places
The decimal symbol and the number of decimal places displayed are different settings. A cell showing a rounded-looking value may be using a number format with fewer visible places; that does not necessarily mean the underlying value has changed.
In Excel, select the affected cell and inspect its number format on the Home tab. Adjust the displayed decimal places if appropriate, and check the underlying value before deciding whether the separator is wrong. Test in a blank cell as well: an existing cell may be formatted differently from a new one.
Imported text or CSV values are still wrong
A file may use a different decimal convention from your current Windows or Excel settings. It may also use a comma or semicolon to separate columns, which is distinct from the character inside a decimal value.
Before reimporting: work from the original file or a copy. Do not use a blanket find-and-replace on important figures; the same punctuation may have different meanings in different fields.
In Excel, Microsoft’s legacy Text Import Wizard lets you specify the decimal and thousands separators used by the source file:
- If the legacy wizard is not available, select File > Options > Data and, under Show legacy data import wizards, select From Text (Legacy). Select OK.
- Select Data > Get Data > Legacy Wizards > From Text (Legacy), then open the source text file.
- In the wizard, choose the appropriate file layout and field delimiter. Review the preview to make sure values are split into the correct columns.
- On Step 3 of 3, select Advanced and specify the decimal and thousands separators used in the source data.
- Finish the import into a new worksheet and compare several results with the original file, including fractional and large values.
If Excel has already misinterpreted or stored values as text, changing the Windows separator afterward does not reliably reconstruct what the file originally meant. Reimport from the original and verify the results before replacing any existing workbook.
The setting changed back or cannot be changed
Reopen the Numbers tab and check whether the saved symbols are still present. If they are, investigate the affected app rather than repeatedly changing Windows.
On a managed work or school PC, contact IT if the setting cannot be saved or repeatedly returns to another value. Provide the current regional format, the desired decimal and grouping symbols, and the name of the affected app.
Restore the previous settings
To undo the Windows change:
- Press Windows key + R, type
intl.cpl, and press Enter. - Select Formats > Additional settings > Numbers.
- Restore the decimal and digit-grouping symbols you recorded before making the change.
- Select OK in both dialogs and reopen the affected app.
- If you also changed the overall Regional format in Settings, restore the previous format there and recheck the symbols in Additional settings.
Finally, test a fresh fractional value and confirm that it displays and calculates as expected. If existing files still contain incorrectly interpreted values, restore or reimport from the original data rather than relying on the formatting rollback to repair them.