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 FOR...
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: