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 ?
>Solution :
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.