Fix Comma Decimal Numbers Not Working in Excel Formulas
Question details
The user needs Excel to recognize comma-decimal values as numbers so they can be used in 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.
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.
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.
In Excel, select File > Options, then choose Advanced.
Under Editing options, clear Use system separators. Set Decimal separator to a comma and Thousands separator to a period.
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.

Convert imported comma-decimal text to numbers
Use Text to Columns if existing values remain stored as text after you check the separator settings.
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.

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.




