Forum Discussion
FORMAT function bug
Hello,
When I use thousand separator in FORMAT function
FORMAT ( Number, "+#,##0.0%;-#,##0.0%" )
I get number with space separator instead of dot. How can I fix it?
If I don't use FORMAT function, everything is fine, separator is dot.
Any help would be appreciated 🙂
3 Replies
I have fixed it! The problem was in my computer settings. Space was set as thousand separator. I changed it to a dot.
Gintar12 , do you country setting which uses decimal as , and thousand separator --> .
Seem like that has been forced on number
Try like
FORMAT ( Number, "+###.##0,0%;-###.##0,0%" )
I have tried it. But it is not working. I got:
