Thread: Format Number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Abdul[_2_] Abdul[_2_] is offline
external usenet poster
 
Posts: 137
Default Format Number

I am trying to format the number 12345612345123456 to display as
123456 12345 123456 by entering a custom format code 000000 00000
000000. But the result display like 123456 12345 123400. Instead of
the last digits 56 it displays 00. ??

Thanks