Forum Discussion
Michael Lattrell
Nov 28, 2017Copper Contributor
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 ...
Hunter Willis
Nov 28, 2017Iron Contributor
You can set this in Excel by going to Format Cells-Number-Custom.
Michael Lattrell
Nov 29, 2017Copper Contributor
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).