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

G

Greg

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

mixing zip with zip+4 and then sorting 2
Query with Zip Code Mis-match (5 digit vs 9 digit) 3
Zip Code Last 4 Digit as Zero 1
Validate zip codes 8
How do I format zip code (9) to use in Word merg doc 1
Excel 2002: Can I sort columns of the Pivot Table ? 2
only 5 digit zip codes 1
Excel 2007 is stupid dealing with zipcodes 2

Top