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

%3CLINGO-SUB%20id%3D%22lingo-sub-324495%22%20slang%3D%22en-US%22%3EHow%20to%20change%20the%20style%20used%20to%20separate%20thousands%20or%20decimals%20on%20Office%20365%20Essentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-324495%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Sirs%2C%3CBR%20%2F%3E%3CSPAN%3EI%20use%20dot%20instead%20of%20comma%20to%20separate%20the%20thousands%20in%20my%20country.%20In%20Excel%20from%20my%20Office%20365%20Essentials%20I%20could%20not%20find%20how%20to%20change%20this%20default.%20I%20can%20only%20activate%20or%20deactivate%20the%20comma%20for%20thousands.%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22tw-swapa%22%3E%3CDIV%20class%3D%22DHcWmd%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-324495%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326772%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20the%20style%20used%20to%20separate%20thousands%20or%20decimals%20on%20Office%20365%20Essentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326772%22%20slang%3D%22en-US%22%3E%3CP%3EI%20guess%20for%26nbsp%3BOffice%20365%20Business%20Essentials%20there%20are%20only%20Web%20applications%20(Excel%20Online)%2C%20if%20so%20that's%20tenant%20admin%20shall%20change%20locale%20for%20OneDrive.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326483%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20the%20style%20used%20to%20separate%20thousands%20or%20decimals%20on%20Office%20365%20Essentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326483%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20could%20try%20checking%20your%20system%20settings%20if%20you%20have%20admin%20rights%20-%20which%20you%20may%20not%20be%20able%20to%20change%20if%20controlled%20by%20your%20business.%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%20picture...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-933971%22%20slang%3D%22de-DE%22%3ERe%3A%20How%20to%20change%20the%20style%20used%20to%20separate%20thousands%20or%20decimals%20on%20Office%20365%20Essentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-933971%22%20slang%3D%22de-DE%22%3E%3CP%3EWe%20have%20same%20problem%20here.%20in%20Germany%20it%20is%201%2C000%2C00%20and%20not%20the%20english%20version%201%2C000.00%20.%20%3CBR%20%2F%3EIn%20local%20Windows%2010%20Clients%20%2C%20local%20Excel365%20it%20is%20displayed%20correctly.%20If%20you%20open%20same%20file%20in%20Excel-Web%2C%20it%20is%20displayed%20in%20english%20form.%26nbsp%3B%3CBR%20%2F%3EOur%20Users%20(one-drive-data....)%20are%20all%20localized%20in%20Germany...%20so%20that%20does%20not%20help.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-934034%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20the%20style%20used%20to%20separate%20thousands%20or%20decimals%20on%20Office%20365%20Essentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-934034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F431575%22%20target%3D%22_blank%22%3E%40HolgerKastern%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20in%20England%20we%20had%20the%20same%20problem.%26nbsp%3B%20We%20have%20dates%20in%20Excel%20that%20are%20in%20English%20and%20if%20we%20upload%20to%20our%20users%20(in%20England)%20who%20use%20Excel%20for%20web%2C%20the%20dates%20are%20displayed%20in%20American%20format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20change%20this%2C%20you%20have%20to%20log%20into%20your%20Office%20365%20WEB%20version%20of%20Excel%20and%20make%20the%20changes%20in%20the%20settings%20there.%26nbsp%3B%20The%20other%20issue%20we%20had%20was%20that%20our%20WEB%20version%20of%20Excel%20Office%20365%20was%20set%20up%20by%20our%20IT%20team%20who%20had%20locked%20ordinary%20users%20out%20from%20making%20such%20changes%20so%2C%20the%20option%20was%20'Greyed-out'%20to%20us.%26nbsp%3B%20Systems%20had%20to%20make%20the%20changes%20as%20we%20didn't%20have%20the%20access%20to%20carry%20the%20change%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-934114%22%20slang%3D%22de-DE%22%3ERe%3A%20How%20to%20change%20the%20style%20used%20to%20separate%20thousands%20or%20decimals%20on%20Office%20365%20Essentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-934114%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F266754%22%20target%3D%22_blank%22%3E%40Nauthstar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESounds%20good.%20but%20where%20in%20Excel%20do%20I%20make%20the%20changes%2C%20cannot%20even%20set%20a%20settings%20section%20there%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-942599%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20the%20style%20used%20to%20separate%20thousands%20or%20decimals%20on%20Office%20365%20Essentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-942599%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F431575%22%20target%3D%22_blank%22%3E%40HolgerKastern%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22arial%2Chelvetica%2Csans-serif%22%3EThis%20fix%20won't%20work%20for%20everyone.%26nbsp%3B%20It's%26nbsp%3Bpotentially%20problematic%20for%20multi-regional%20companies.%26nbsp%3B%20It's%20believed%20to%20be%20a%20MICROSOFT%20BUG%20-%20unless%20someone%20can%20come%20up%20with%20a%20working%20solution.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20face%3D%22arial%2Chelvetica%2Csans-serif%22%3EBasically%2C%20to%20change%20site%20settings%2C%20log%20into%20Office%20365%20as%20a%20site%20admin%2C%20go%20to%20OneDrive%2C%20click%20on%20the%20settings%20icon%20(gears)%2C%20then%20site%20settings.%20In%20here%20under%20site%20administration%20you%20can%20change%20the%20regional%20settings.%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E1.%20Go%20to%20%3CA%20href%3D%22https%3A%2F%2Faccount.live.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faccount.live.com%3C%2FA%3E%20and%20sign%20in%20with%20the%20account%20you%20use%20for%20SkyDrive%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2.%20Go%20Overview%20-%26gt%3B%20Personal%20info%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E3.%20Change%20Home%2C%20Timezone%20etc%20to%20desired%20location.%20Change%20Work%20location%2C%20if%20required.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22x-hidden-focus%22%3E%3CFONT%20face%3D%22arial%2Chelvetica%2Csans-serif%22%3EIn%20the%20bottom%20left%20corner%20of%20the%20window%20(down%20by%20copyright%20yyyy%20Microsoft).%20Although%20it%20appears%20greyed%20out%2C%20you%20can%20click%20on%20the%20language%20setting%20and%20change%20it%20to%20your%20language%20choice%2C%20it%20should%20then%20keep%20those%20settings%20when%20you%20upload%20say%2C%20an%20English%20Excel%20sheet%20which%20is%20then%20opened%20on%20the%20web.%3C%2FFONT%3E%3C%2FDIV%3E%3CDIV%20class%3D%22x-hidden-focus%22%3EHowever%2C%20this%20is%20a%20GLOBAL%20SETTING%20which%20will%20effect%20all%20users%20-%20which%20is%20why%20it%20won't%20work%20for%20multiregional%20organisations%20-%20and%20also%20may%20not%20be%20something%20your%20business%20IT%20let%20you%20have%20access%20to!%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%3CFONT%20face%3D%22arial%2Chelvetica%2Csans-serif%22%3EYou%20will%20need%20to%20check%20this%20in%20your%20Office%20Online%20drive%20to%20make%20sure%20your%20spreadsheet%20has%20not%20reverted%20back%20to%20US%20style%20formats%20for%20dates%20and%20numbers.%3C%2FFONT%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-942610%22%20slang%3D%22de-DE%22%3ERe%3A%20How%20to%20change%20the%20style%20used%20to%20separate%20thousands%20or%20decimals%20on%20Office%20365%20Essentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-942610%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F266754%22%20target%3D%22_blank%22%3E%40Nauthstar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emany%20thanks%20for%20answering.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20out%20instantly.%3C%2FP%3E%3CP%3EUnluckily%20account.live.com%20seems%20to%20be%20unworking%20for%20business%20accounts%20(just%20private%20account).%3C%2FP%3E%3CP%3E-%26gt%3B%20so%20it%20does%20not%20help%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHolger%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1792492%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20change%20the%20style%20used%20to%20separate%20thousands%20or%20decimals%20on%20Office%20365%20Essentials%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1792492%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F266754%22%20target%3D%22_blank%22%3E%40Nauthstar%3C%2FA%3E%26nbsp%3B%20-%20Your%20screenshot%20looks%20just%20like%20what%20I%20want...%20but%20I%20cannot%20work%20out%20how%20to%20get%20there!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20English%20version%20of%20the%20Systeme%20Internationale%20(SI)%2C%20we%20are%20required%20to%20use%20a%20non-breaking%20space%20to%20group%20thousands.%20Commas%20or%20points%20are%20not%20allowed.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 the comma for thousands.

 
8 Replies

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...

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.

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.

@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.

@Nauthstar 

 

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

@HolgerKastern 

 

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.

 

In the bottom left corner of the window (down by copyright yyyy Microsoft). Although it appears greyed out, you can click on the language setting and change it to your language choice, it should then keep those settings when you upload say, an English Excel sheet which is then opened on the web.
However, this is a GLOBAL SETTING which will effect all users - which is why it won't work for multiregional organisations - and also may not be something your business IT let you have access to!
 
You will need to check this in your Office Online drive to make sure your spreadsheet has not reverted back to US style formats for dates and numbers.

 

@Nauthstar 

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.

 

Holger

@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.