Forum Discussion

Michael Lattrell's avatar
Michael Lattrell
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
betooonc's avatar
betooonc
Copper Contributor
Oct 06, 2021

MarcAnderson Hi, I don't have that option in online excel 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 06, 2021

betooonc 

In Excel for web regional settings are  under File menu here

  • DavidMaldonado's avatar
    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. 

  • dvirant905's avatar
    dvirant905
    Copper Contributor
    Jun 21, 2022

    Has anyone managed to solve this? 

     

    It's not a Windows setting - or rather, you can change the Windows setting and it will work in the desktop version of Excel, but there seems to be no way to change it in the ONLINE version of Excel. Emphasis on ONLINE.

Resources