Formatting Issues

Fix Incorrect Currency Separators in Excel for the Web

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

The user needs Excel for the web to display US currency values with a decimal point after uploading workbooks to OneDrive.

Fix Incorrect Currency Separators in Excel for the Web
Product
Microsoft Excel for the web
Device & OS
not provided
Scenario
Workbooks are uploaded to OneDrive and opened in Excel for the web.
Observed behavior
Currency values appear with a comma as the decimal separator online, such as $500,00, but display correctly in desktop Excel.
Before you start

Open an affected workbook in Excel for the web and compare a currency cell with the same cell in desktop Excel. Check whether the separator issue occurs in other uploaded workbooks as well.

Solution 1Recommended

Set the regional format to English (United States)

Use this when currency separators differ online across multiple workbooks but appear correctly in desktop Excel.

1
Open regional settings

In Excel for the web, open an affected workbook and select File > Options > Regional Settings.

2
Choose the US region

Select English (United States) or the United States regional format, then confirm the change. Check whether the currency cells now display a decimal point.

3
Review Microsoft 365 settings

If the issue persists, select your Microsoft 365 profile picture and open My profile. Look for the option to update your profile and change Language and Region, then choose the appropriate personal regional settings.

4
Ask an administrator

If regional options are unavailable or the issue affects multiple users, contact your Microsoft 365 administrator to review the organization’s regional configuration.

Settings may vary: Profile and regional-setting options can vary by Microsoft 365 configuration. Changing a display language alone may not change the regional number format.
Free Microsoft Office alternative

Work with Currency Formats in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheets to continue working with currency formats while you review your Microsoft 365 settings.

Apply currency formatting to spreadsheet cellsOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface to ease the move from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel for the web show $500,00 instead of $500.00?

A regional format that uses a comma as the decimal separator may be active online. In the workbook, check File > Options > Regional Settings and select an appropriate US regional format.

Will setting two decimal places change the decimal separator?

No. Select the cells and use the Home tab’s Number Format menu to control currency formatting and decimal places. Change the regional format if the separator itself is incorrect.

Why is the workbook correct in desktop Excel but not online?

Desktop Excel and Excel for the web can use different regional settings. Compare the web app’s regional format with the settings used on the computer where the file displays correctly.

What should I do if every uploaded workbook has the same issue?

Check your Excel for the web regional settings and your Microsoft 365 profile’s Language and Region settings. If you cannot change them or other users are affected, ask your Microsoft 365 administrator to review the organization’s configuration.