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
only 5 digit zip codes 1
Query with Zip Code Mis-match (5 digit vs 9 digit) 2
Excel 2002: Can I sort columns of the Pivot Table ? 2
Changing ZIP code formats in Excel 2003 6
Validate zip codes 8
How do I format zip code (9) to use in Word merg doc 1
How do I convert zip+4 to 5-digit zip? 2

Top