I'm looking for a solution to format my number as folow : 123456789 -> 12 345 6789 When I try to use a custom format as "## ### ####" it's not working and Excel return 123 456 789

Is there a way to do that ?

CodePudding user response：

If the user defined number format ## ### #### results in 123 456 789 for you, then the space is set to be the thousands separator in your system or your Excel. If so, then a simple space in a number format always means the thousands separator which separates thousands always and nothing else.

But you can use the user defined number format ##\ ###\ #### or ##" "###" "####. That uses the space character as a character independent of it's special meaning.

CodePudding user response：

On my PC this is working fine, as you can see:

I believe there might be a problem with your Excel version. I'm working with Excel 365.

As the thousands separator, I don't have the space character, but another one, as you can see here: