How do I zip sort mailing list when I have 5 digit AND 9 digit zip
 

I have a mailing list with zips in XXXXX and XXXXX-XXXX all mixed in. When I
sort them, it seems to put all the 5 digits on the top half and 9 digits on
the bottom half. I have made sure the column settings are set to
special/zipcode. I have also tried setting them as Zip Code + 4 but it
converts all the XXXXX versions to 0000X-XXXX. What am I doing wrong?

How do I zip sort mailing list when I have 5 digit AND 9 digit zip
 

Convert to TEXT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Greg" wrote in message
...
I have a mailing list with zips in XXXXX and XXXXX-XXXX all mixed in. When
I
sort them, it seems to put all the 5 digits on the top half and 9 digits
on
the bottom half. I have made sure the column settings are set to
special/zipcode. I have also tried setting them as Zip Code + 4 but it
converts all the XXXXX versions to 0000X-XXXX. What am I doing wrong?