6 DIGITS

[Dave]

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

 

[Mike H]

dave,

Apply a custom format of 000000

Mike