Forum Discussion
Figure/Number format to display with comma
Hi Everyone ;-) We work on sharepoint. Where we set-up financials in excel and word. These files are then worked on by various groups. Normally we use this format: ## ##0;(## ##0);"–" ...
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?
Screenshot of PC interface