Nov 28 2017
12:55 AM
- last edited on
Feb 06 2023
03:48 AM
by
TechCommunityAP
Nov 28 2017
12:55 AM
- last edited on
Feb 06 2023
03:48 AM
by
TechCommunityAP
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!
Nov 28 2017 12:44 PM
You can set this in Excel by going to Format Cells-Number-Custom.
Nov 29 2017 02:33 AM
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).
Dec 30 2020 02:20 PM
Jan 03 2021 03:45 AM
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.
Jun 29 2021 01:28 AM
You can use Control Panel > Region > Additional Settings > Decimal Symbol
Oct 06 2021 09:43 AM
@MarcAnderson Hi, I don't have that option in online excel
Oct 06 2021 01:33 PM
Hi @betooonc - it's a Windows setting, not an Excel setting.
Click Start, type "control", select Control Panel App, select Region, select Additional Settings.
At the top of the list, is "Decimal symbol:" with a drop-down selection of 4 options: point, comma, space and apostrophe. Select the option you want and select "OK" to close Additional Settings and select "OK" again to close Region...
Oct 06 2021 01:35 PM
Jun 21 2022 02:23 AM
Has anyone managed to solve this?
It's not a Windows setting - or rather, you can change the Windows setting and it will work in the desktop version of Excel, but there seems to be no way to change it in the ONLINE version of Excel. Emphasis on ONLINE.
Jul 04 2022 08:29 PM
@Sergei Bakla Sergei is wright. Change the regional settings to your country setting and it will change the decimal separator to match your regional setting. In my case I had Spanish (Spain) setting. I changed to Spanish (México) and it worked. I hope it works for you.