Forum Discussion
Figure/Number format to display with comma
Hello,
I can't reproduce the problem. Your blue table uses the custom format
## ##0;(## ##0);"–"
If I change the custom format to ...
##,##0;(##,##0);"–"
... it still works fine for me. However, in my regional settings, the comma is the Thousand separator. There are other regions where the Thousand separator is a dot and the comma is the decimal separator. Maybe that is the problem in your case?
You can quickly test this by entering a number and formatting it with the Currency format. What is used as the Thousand separator?
In my previous post
I have taken a screenshot of my PC interface.
Is that the Region settings you are referring to?
Yes, in a way. The region settings are define at the operating system level, so Windows or Mac, whatever you use. Excel then picks it up from there. I can see that your settings use a decimal comma and a dot as the thousand separator. Since your client wants to use a comma instead, their regional settings are probably different.
If you work with Excel online, with data saved in SharePoint, these two can also have an impact on the display. I read that the settings of the SharePoint site will determine the settings for the separators and if you want to change that you need to change the region settings for the SharePoint site.
Is that anything you can approach?
Thank-you very much for your help Ingeborg.
I will address this with our Manager today and see what she says.
I was hoping there would be another alternative, as that sounds like changing the region settings would effect all the other jobs on sharepoint. Which are fine currently.
Screenshot of PC interface
