Fix Incorrect Currency Separators in Excel for the Web
Question details
The user needs Excel for the web to display US currency values with a decimal point after uploading workbooks to OneDrive.

- 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.
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.
Set the regional format to English (United States)
Use this when currency separators differ online across multiple workbooks but appear correctly in desktop Excel.
In Excel for the web, open an affected workbook and select File > Options > Regional Settings.
Select English (United States) or the United States regional format, then confirm the change. Check whether the currency cells now display a decimal point.
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.
If regional options are unavailable or the issue affects multiple users, contact your Microsoft 365 administrator to review the organization’s regional configuration.
Apply currency formatting to the affected cells
Use this to ensure the selected numeric cells are formatted as currency with two decimal places.
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.

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.




