How to Change the Decimal Separator in Excel for the Web on a Chromebook
Question details
The user wants to replace the standard decimal point with a decimal comma in Excel for the web while working on a Chromebook.
- Product
- Excel for the Web
- Device & OS
- Chromebook
- Scenario
- Customizing number and formula formatting in cloud-based spreadsheet apps.
- Observed behavior
- Excel for the Web displays a decimal point by default, and the user needs it to reflect a comma based on their formatting preferences without altering the display language.
Ensure you have access to your Microsoft 365 account credentials, as Excel for the Web relies on your account's cloud profile settings to determine number formatting.
Adjust Microsoft Account Regional Settings
Change your Microsoft account's region to a locale that utilizes a comma as the default decimal separator.
Unlike the desktop version of Excel, Excel for the Web does not have a dedicated 'Advanced' options menu to override system separators. Instead, it reads the regional settings directly from your Microsoft account.
Open your browser on the Chromebook and sign in to your Microsoft account at the official account management portal.
Navigate to the 'Your info' tab at the top of the account dashboard.
Scroll down to the 'Language info' section and click on 'Country or region'. Change this setting to a country that uses a comma as a decimal separator (for example, Germany, France, or Brazil).
Save your profile changes, close any open Excel web tabs, and reopen Excel for the Web to see the updated decimal comma applied to your numbers and formulas.
Customize Decimal Separators Easily in WPS Spreadsheet
If you want precise control over your decimal formats without altering your entire account's regional settings, WPS Office provides a powerful and lightweight alternative that gives you direct access to formatting options.
- 1. Open WPS Spreadsheet: Launch WPS Office and open your workbook.
- 2. Navigate to Options: Click the 'Menu' button in the top-left corner and select 'Options' from the drop-down list.
- 3. Adjust Separators: Go to the 'Advanced' or 'General and Save' settings, uncheck 'Use system separators', and manually type a comma (,) into the 'Decimal separator' box.
- 4. Save Changes: Click 'OK'. Your spreadsheet will immediately update to display the chosen decimal comma without requiring a browser reload.
Frequently Asked Questions
Does changing the regional setting in Excel for Web affect other Microsoft apps?
Yes. Because Excel for the Web relies on your overarching Microsoft account's regional settings, changing the country or region will apply those default formats to other web-based Microsoft 365 applications.
Can I change the decimal separator in Excel for Web without changing my region?
Currently, Excel for the Web does not offer a standalone feature to toggle decimal separators independently. You must adjust your account's regional profile. To customize it independently, you would need to use a desktop spreadsheet application like WPS Office or Microsoft Excel for Desktop.
Will my Excel interface change to a different language if I change the region?
No. Microsoft separates 'Display Language' from 'Regional Format'. As long as you only change the country or region for formatting, your menus, buttons, and overall UI will remain in your preferred language.
