Zip code sorting is a problem using excel 2003. I have zips both in 4 and 9
digit format. I have tried every conceivable format and even followed the
recommendation online by typing in the custom category
[<=99999]00000;00000-0000.
I have tried to retype in the zip codes but that doesnt seem to help.
Note that some info comes in from older excel versions and from Word docs.
Can anyone help?