Padding with leading zeros

[Guest]

How can I get a column of numbers to appear as 3 positions alpha with leading
zeros as needed

e.g.

1 appears as 001
2 appears as 002
99 apears as 099
999 apears as 999

 

[Guest]

Try:

Format|cells|custom

000 as a custom format

Mike

 

[Gord Dibben]

Custom format as 000


Gord Dibben MS Excel MVP