FORMAT function bug

[Gintar12]

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 🙂

[Gintar12]

I have fixed it! The problem was in my computer settings. Space was set as thousand separator. I changed it to a dot.

[amitchandak]

@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%" )

[Gintar12]

I have tried it. But it is not working. I got: