Thread: 6 DIGITS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 6 DIGITS

Hi

I have a column with numbers from 1 to 999999. I would like to be able to
show the numbers with 6 digits i.e. 000001, 000002, 001001 to 999999 ETC.

How do I do this?

Thanks