Nov 28 2017 12:55 AM - edited Nov 28 2017 12:57 AM
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.
Jul 21 2022 09:21 AM
Hello, @Michael Lattrell, yes the standards of different countries and cultures cause situations when you have to change dots to commas and vice versa.
If you need to replace commas with dots, do the following steps:
1) Choose the range of the data to be changed and where the symbols should be replaced.
2) In the Editing group section on the Home tab, hit the Find & Select.
3) Go to Find & Select list, and select Replace.
4) Find the Replace tab in the Find and Replace dialog box and do the following:
Enter the symbol to be replaced in the Find what field as shown here and replace it with the symbol you need as a result.
If you are a Microsoft 365 administrator, this link will also be helpful.