Format a number in a scecial way

  • Thread starter Thread starter Kathrine
  • Start date Start date
K

Kathrine

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?
 
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?
 
A custom format of:
000 00 000
Worked fine for me.

What happened when you tried it?
 
If the number appears in the left side of the cell it was entered as text and
will need to be converted to value to get the custom formatting to work.

Tom
 
Back
Top