Calculation Issues

Fix Comma Decimal Numbers Not Working in Excel Formulas

Amos GikundaAmos Gikunda Nov 18, 2026 869 views

Question details

The user needs Excel to recognize comma-decimal values as numbers so they can be used in formulas.

Fix Comma Decimal Numbers Not Working in Excel Formulas
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet contains imported values such as 100,20 and 20,00 that use a comma as the decimal separator.
Observed behavior
Excel may treat the values as text when its separator settings do not match the imported data.
Before you start

Check that the source data uses a comma for decimals and, if applicable, a period for thousands. Identify the affected column and confirm whether its values are being treated as text.

Solution 1Recommended

Set Excel to use a comma as the decimal separator

Use this setting when Excel's separators do not match your comma-decimal data.

These instructions apply to Excel for Windows. Changing the separators may not automatically convert values that are already stored as text.

1
Open Excel options

In Excel, select File > Options, then choose Advanced.

2
Change the separators

Under Editing options, clear Use system separators. Set Decimal separator to a comma and Thousands separator to a period.

3
Apply and test

Click OK, then enter a comma-decimal value in a cell and test it in a formula. If existing values still behave as text, convert them using Text to Columns.

Set Excel to use a comma as the decimal separator
Free Microsoft Office alternative

Work with spreadsheet data in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility, making it easy to move existing workbooks into WPS Spreadsheets.

Open and edit Microsoft Excel XLS and XLSX workbooksWork with imported spreadsheet values and formulasUse a familiar interface for a smoother transition from ExcelAccess free core office tools in a lightweight suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel treat 100,20 as text?

Excel may expect a period rather than a comma as the decimal separator. Check File > Options > Advanced and compare the separator settings with the source data.

Will changing Excel's separators convert existing text values?

Not necessarily. Select the affected column and use Data > Text to Columns, then set the source decimal and thousands separators under Advanced before clicking Finish.

Can I change the separators for Excel without changing Windows settings?

Yes. In Excel for Windows, go to File > Options > Advanced, clear Use system separators, and enter the separators you want Excel to use.

How can I check whether a value is stored as text?

Enter =ISNUMBER(A1) in an empty cell, replacing A1 with the cell to check. FALSE means Excel does not recognize that value as a number.