Padding with leading zeros
 

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

Padding with leading zeros
 

Try:

Format|cells|custom

000 as a custom format

Mike

"GKW in GA" wrote:

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

Padding with leading zeros
 

Custom format as 000


Gord Dibben MS Excel MVP

On Tue, 3 Jul 2007 12:08:03 -0700, GKW in GA
wrote:

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