Calculation Issues

How to Fix Excel Online Not Recognizing Comma Decimal Numbers

Bushra Parveen Oct 22, 2026 868 views

Question details

The user needs Excel Online to correctly identify numbers entered with a comma as decimals rather than text so that existing calculation formulas work properly.

How to Fix Excel Online Not Recognizing Comma Decimal Numbers

Product: Excel Online
Device & OS: not provided
Scenario: Entering numerical data with comma decimals into a spreadsheet and performing calculations using formulas.
Observed behavior: Excel Online treats numbers entered with a comma as text strings, preventing formulas from calculating. Conversely, entering a period might not work if the existing formulas or formats expect a comma.

Before you start

Check your Microsoft account and browser language settings, as web applications rely heavily on these to determine your default decimal and thousands separators.

Solution 1Recommended

Change Regional Format Settings in Excel Online

Adjust your workbook's regional settings to a country that uses commas as decimal separators to ensure numbers are recognized correctly.

Excel Online dictates decimal separators based on the region configured in the file settings. Modifying this ensures commas are naturally interpreted as decimal points without breaking calculations.

Open Workbook Options

Launch your spreadsheet in Excel Online, click on the 'File' menu in the top-left corner, and select 'Options'.

Access Regional Settings

Click on 'Regional Format Settings' from the options menu.

Select a Comma-Based Region

Choose a region from the dropdown menu that standardizes commas as decimals (such as Germany, France, or Spain).

Apply and Refresh

Click 'Change' to apply the new format. Refresh your browser page to ensure Excel Online processes your existing comma-separated inputs as valid numbers.

Formulas Automatically Update: Once the region is updated, text values formatted with commas should be instantly recognized as numbers, and any dependent formulas will recalculate successfully.

Solution 2

Update Cell Formatting to Number

Ensure the cells are explicitly formatted as numbers rather than text or general formatting.

Solution 3

Use the Format Painter to Apply Correct Properties

Copy the working format from a cell that correctly calculates decimals and apply it to the broken cells.

Easily Customize Decimal Separators Offline with WPS Spreadsheet

If browser-based regional settings are causing persistent calculation errors, WPS Spreadsheet offers an effortless way to manually define your decimal and thousands separators directly within the application. You can work fully offline while avoiding browser sync conflicts.

1. Open Your Spreadsheet: Launch WPS Office and open your .xlsx file in WPS Spreadsheet.
2. Access the Options Menu: Click on 'Menu' in the top left corner of the interface and select 'Options' from the drop-down list.
3. Navigate to Edit Settings: In the Options dialog box, select the 'Edit' tab from the left-hand sidebar.
4. Disable System Separators: Scroll down to find the 'Use system separators' checkbox and uncheck it to enable manual override.
5. Set Comma as Decimal: Type a comma (,) into the 'Decimal separator' field and click 'OK' to instantly apply the setting to all your calculations.

Customizable advanced options for decimal and thousands separatorsFully compatible with Microsoft Excel (.xlsx) file formats and formulasWorks completely offline without browser-based regional sync issuesFree, lightweight, and features a familiar user interface

Frequently Asked Questions

Why does Excel treat my decimal numbers as text?

This happens when the decimal separator you type (such as a comma) does not match the default separator defined by your region settings. Consequently, Excel does not recognize the input as a number and defaults to reading it as a standard text string.

How do I fix formulas that stopped working after entering periods?

If your account's regional settings expect a comma as the decimal separator, entering a period makes Excel read the input as text, breaking the formula. You can either change the periods back to commas, or update your regional settings in Excel Online to accept periods.

Does changing my region in Excel Online affect other Microsoft applications?

Yes, modifying your regional format settings in Excel Online typically updates the language and region preferences across your entire Microsoft account. This means applications like Word Online and OneDrive will also adopt the newly selected regional standards.

Excel & Data Problems