How to Fix Decimal Separators in Excel for the Web (Swiss French Settings)
Question details
The user needs to understand why Excel for the web is displaying commas instead of periods as decimal separators when using Swiss French regional settings, and how to fix or work around the issue.
- Product
- Microsoft Excel for the Web
- Device & OS
- not provided
- Scenario
- Working with numeric data in Excel for the web while expecting Swiss French formatting conventions.
- Observed behavior
- Excel for the web displays commas for decimal separators instead of the expected periods, failing to fully honor the Swiss French regional configuration.
Before proceeding, verify that your computer's operating system regional settings and your browser's preferred language are both set to French (Switzerland).
Isolate and Clear Browser Cache
Determine if the browser is overriding web settings by testing the spreadsheet in a private browsing session.
Often, Excel for the web relies on cached browser data or browser-level locale preferences, which can override your Microsoft 365 regional settings. Testing in a private window helps bypass these conflicts.
Launch your web browser (e.g., Edge or Chrome) and open a new Private or Incognito window.
Log into your Microsoft 365 account, open your Excel workbook, and check if the decimal separators now correctly display as periods.
If the formatting is correct in the private session, return to your normal browser window, navigate to the browser settings, and clear your cache and cookies.
If you are using Microsoft Edge and the issue persists, try navigating to C:\Users\UserName\AppData\Local\Microsoft\Edge\User Data\ and renaming the 'Default' folder to force a new user profile.
Apply a Manual Workaround in Excel Desktop
Bypass the web formatting limitation by forcing custom decimal separators in the desktop version of Excel.
Verify Microsoft 365 Regional Settings
Ensure your overarching Microsoft account settings are enforcing the Swiss French locale.
Experience Flawless Formatting with WPS Office
When web-based spreadsheet tools like Excel for the web fail to recognize specific regional formats like the Swiss French decimal period, switching to a powerful desktop alternative is the best solution. WPS Office is a free, highly compatible suite that perfectly respects your customized system settings.
Frequently Asked Questions
Why does Excel for the web use commas instead of periods for Swiss French?
Excel for the web relies heavily on a combination of your browser's language preferences and your Microsoft 365 account settings. Sometimes it defaults to standard French formatting (which uses commas for decimals) rather than the specific Swiss French format (which uses periods).
Can I permanently change the decimal separator directly in Excel for the web?
Excel for the web lacks the detailed 'Advanced Options' menu found in the desktop version. To change the separator permanently online, you must adjust your Microsoft 365 account's overarching Language and Region settings, or rely on the desktop application to uncheck 'Use system separators'.
Will changing my computer's regional settings fix the web version of Excel?
It can help, but it is not guaranteed. While desktop apps directly read your OS settings, web apps like Excel Online prioritize browser locale and cloud account settings. Ensuring your web browser's primary language is explicitly set to 'French (Switzerland)' is often more effective.
