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

  • Thread starter Thread starter Greg
  • Start date Start date
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?
 
Back
Top