The secret is to find the special format for zip codes and format them all
that way. Select the cells with zips and delete all the ' marks, and - marks
if any, using the Replace function. Then go to Format-Cells. Click on the
Number tab and select Special. There is one format for 5-digit zips and
another for 9-digit (which automatically inserts the hyphen). If you enter a
zip beginning with a zero, the leading zero will show. They will sort from
00001 to 99999, but you will find you cannot mix 5- and 9-digit zips--use
one or the other but not both.

"Pat Hughes" <Pat wrote in message
...
How do you sort zip codes where some of them start with 0? I have changed
the format to text, number, general with no luck. I would like to be able
to
do this without having to put a ' in front of the number.