Space as thousand seperator using Format()

[Anonymous]

Hi,

I need to use a space as thousand seperator in my format function: 

In this example i used ',' as a seperator and everything is fine:

when I change the ',' with a ' ' (space) you see the formatted text is all messed up. 

any idea? 

[amitchandak]

@Anonymous , Try like

"# ###.##"

[Anonymous]

Hi @amitchandak , 

as you can see below, when the number > 1M , it doesn't show the seperator with your solution.

[amitchandak · Accepted solution]

@Anonymous , In case comma, it does it automatically

try

"### ### ###.##"

[Anonymous]

I was looking for a more generic or automatic way, but if there is no other solution I will have to do it this way .. 

Thanks for your answers.