Excel Online - Change default decimal separator

%3CLINGO-SUB%20id%3D%22lingo-sub-131779%22%20slang%3D%22en-US%22%3EExcel%20Online%20-%20Change%20default%20decimal%20separator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131779%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20my%20Country%20the%20standard%26nbsp%3Bfor%20the%20decimal%20separator%20is%20dot%2C%20but%20in%20our%20Office%20365%20environment%20every%20excel%20file%20we%20have%20uploaded%20changes%20from%20dot%20to%20comma%20as%20a%20separator%20when%20working%20online%20on%20the%20file.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20far%20as%20i%20know%2C%20such%20issues%20are%20related%20to%20country%20and%2For%20language%20settings.%20But%20neither%20setting%20the%20language%20in%20outlook%20nor%20setting%20the%20language%20under%20my%20profile%20helps.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDoes%20anybody%20may%20have%20other%20ideas%20how%20to%20solve%20this%20problem%2C%26nbsp%3Bwhich%20affects%20all%20my%20users%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-131779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-132230%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20-%20Change%20default%20decimal%20separator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-132230%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Hunter%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThanks%20for%20your%20help%20and%20advice.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20Excel%20online%20i'm%20able%20to%20open%20the%20context%20window%20for%20cells%20number%20customization%2C%20but%20doesnt%20allow%20my%20to%20add%20custom%20number%20formats.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESo%20the%20case%20keeps%20beeing%20strange%2C%20as%20the%20original%20file%2C%20which%20was%20produced%20locally%20keeps%20showing%20the%20dot%20as%20separator%20even%20after%20downloading%20it%20back%20down%20from%20onedrive%20(or%20sharepoint).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-132048%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20-%20Change%20default%20decimal%20separator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-132048%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20set%20this%20in%20Excel%20by%20going%20to%20Format%20Cells-Number-Custom.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2023472%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20-%20Change%20default%20decimal%20separator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2023472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F98235%22%20target%3D%22_blank%22%3E%40Michael%20Lattrell%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhere%20you%20ever%20able%20to%20fix%20this%20problem%3F%20I%20would%20like%20your%20advice%20on%20this.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2027519%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Online%20-%20Change%20default%20decimal%20separator%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2027519%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F914659%22%20target%3D%22_blank%22%3E%40srivasinstax%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20Online%20takes%20separators%20in%20accordance%20to%20regional%20settings%20for%20your%20OneDrive%2FSharePoint%20site%20where%20the%20file%20is%20kept.%20Please%20try%20to%20change%20your%20locale%20here.%20If%20you%20are%20on%20business%20account%20that's%20within%20site%20settings%2C%20for%20personal%20one%20within%20your%20account.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 on the file.

 

As far as i know, such issues are related to country and/or language settings. But neither setting the language in outlook nor setting the language under my profile helps.

 

Does anybody may have other ideas how to solve this problem, which affects all my users?

 

Thanks!

4 Replies

You can set this in Excel by going to Format Cells-Number-Custom. 

Hi Hunter

 

Thanks for your help and advice.

 

In Excel online i'm able to open the context window for cells number customization, but doesnt allow my to add custom number formats.

 

So the case keeps beeing strange, as the original file, which was produced locally keeps showing the dot as separator even after downloading it back down from onedrive (or sharepoint).

@Michael Lattrell 

Where you ever able to fix this problem? I would like your advice on this.

Thanks

@srivasinstax 

Excel Online takes separators in accordance to regional settings for your OneDrive/SharePoint site where the file is kept. Please try to change your locale here. If you are on business account that's within site settings, for personal one within your account.