View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ayo Ayo is offline
external usenet poster
 
Posts: 489
Default Format a number in a scecial way

Try 000" "00" "000
This should work.

"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?