Forum Discussion

Alexandre_Bittencourt's avatar
Alexandre_Bittencourt
Copper Contributor
Jan 23, 2019

How to change the style used to separate thousands or decimals on Office 365 Essentials

Dear Sirs, I use dot instead of comma to separate the thousands in my country. In Excel from my Office 365 Essentials I could not find how to change this default. I can only activate or deactivate t...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 28, 2019

I guess for Office 365 Business Essentials there are only Web applications (Excel Online), if so that's tenant admin shall change locale for OneDrive.

  • HolgerKastern's avatar
    HolgerKastern
    Copper Contributor
    Oct 23, 2019

    We have same problem here. in Germany it is 1.000,00 and not the english version 1,000.00 .
    In local Windows 10 Clients , local Excel365 it is displayed correctly. If you open same file in Excel-Web, it is displayed in english form. 
    Our Users (one-drive-data....) are all localized in Germany...so that does not help.

    • Nauthstar's avatar
      Nauthstar
      Iron Contributor
      Oct 23, 2019

      HolgerKastern 

      Hi, in England we had the same problem.  We have dates in Excel that are in English and if we upload to our users (in England) who use Excel for web, the dates are displayed in American format.

       

      To change this, you have to log into your Office 365 WEB version of Excel and make the changes in the settings there.  The other issue we had was that our WEB version of Excel Office 365 was set up by our IT team who had locked ordinary users out from making such changes so, the option was 'Greyed-out' to us.  Systems had to make the changes as we didn't have the access to carry the change out.

       

      Hope this helps.

      • HolgerKastern's avatar
        HolgerKastern
        Copper Contributor
        Oct 23, 2019

        Nauthstar 

         

        sounds good. but where in Excel do I make the changes, cannot a even settings section there

Resources