Forum Discussion

Copper Contributor

Nov 28, 2017

Excel Online - Change default decimal separator

Hi In my Country the standard for the decimal separator is dot, but in our Office 365 environment every excel file we have uploaded changes from dot to comma as a separator when working online ...

Microsoft 365 Apps

office 365

SergeiBaklan

MVP

Jan 03, 2021

srivasinstax

Excel Online takes separators in accordance to regional settings for your OneDrive/SharePoint site where the file is kept. Please try to change your locale here. If you are on business account that's within site settings, for personal one within your account.

MarcAnderson

Copper Contributor

Jun 29, 2021

SergeiBaklan @srivasinstax

You can use Control Panel > Region > Additional Settings > Decimal Symbol

betooonc
Copper Contributor
Oct 06, 2021
MarcAnderson Hi, I don't have that option in online excel
- SergeiBaklan
  MVP
  Oct 06, 2021
  betooonc
  
  In Excel for web regional settings are under File menu here
  - DavidMaldonado
    Copper Contributor
    Jul 05, 2022
    @Sergei Bakla Sergei is wright. Change the regional settings to your country setting and it will change the decimal separator to match your regional setting. In my case I had Spanish (Spain) setting. I changed to Spanish (México) and it worked. I hope it works for you.
- MarcAnderson
  Copper Contributor
  Oct 06, 2021
  Hi betooonc - it's a Windows setting, not an Excel setting.
  Click Start, type "control", select Control Panel App, select Region, select Additional Settings.
  At the top of the list, is "Decimal symbol:" with a drop-down selection of 4 options: point, comma, space and apostrophe. Select the option you want and select "OK" to close Additional Settings and select "OK" again to close Region...