Leading Zeros

Posted by Tom P on January 16, 2002 8:42 AM

I have a column of cells formatted with a custom format of 000. When I enter a number into the cell example 021 the cell shows 021, but in the Formula bar is shows 21, it drops the zero. This is a problem when I go and do a sort, the sort does not sort in the right order. Any suggestions?

Posted by Mark W. on January 16, 2002 8:46 AM

Format your cells as Text and re-enter values with leading zero (nt)

Posted by iml on January 16, 2002 10:00 AM

You may want to also put a formula next to you column
=TEXT(A1,"000")
and copy it down and sort by that.

good luck