Just tried using Format/Cells - Special

000 00 000

and it formatted as 123 45 678

Using 9 characters gave me 1234 56 789

Perhaps you didn't have the desired cell highlighted when changing the
formatting?

"Kathrine" wrote:

I need to know how to make a format for å number.

The number is in 8 digits - ex. 12345678

I want it to show like this 123 45 678 (with spaces between). How can I set
up this format when formatting my cells. I have tried 000 00 000 but it does
not work.....

Any help?