01-23-2019 10:22 AM
01-23-2019 10:22 AM
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 the comma for thousands.
01-28-2019 03:22 AM
You could try checking your system settings if you have admin rights - which you may not be able to change if controlled by your business.
See attached picture...
01-28-2019 11:30 AM
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.
10-23-2019 02:34 AM
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.
10-23-2019 02:56 AM
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.
10-23-2019 03:16 AM
sounds good. but where in Excel do I make the changes, cannot a even settings section there
10-24-2019 01:33 AM
This fix won't work for everyone. It's potentially problematic for multi-regional companies. It's believed to be a MICROSOFT BUG - unless someone can come up with a working solution.
Basically, to change site settings, log into Office 365 as a site admin, go to OneDrive, click on the settings icon (gears), then site settings. In here under site administration you can change the regional settings.
1. Go to https://account.live.com and sign in with the account you use for SkyDrive
2. Go Overview -> Personal info
3. Change Home, Timezone etc to desired location. Change Work location, if required.
10-24-2019 01:38 AM
many thanks for answering.
I tried out instantly.
Unluckily account.live.com seems to be unworking for business accounts (just private account).
-> so it does not help me.
10-17-2020 08:19 PM
@Nauthstar - Your screenshot looks just like what I want... but I cannot work out how to get there!
In the English version of the Systeme Internationale (SI), we are required to use a non-breaking space to group thousands. Commas or points are not allowed.