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.

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

Resources