Forum Discussion
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 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!
10 Replies
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.
You can use Control Panel > Region > Additional Settings > Decimal Symbol
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).
