I only use 4 digit zip coding, but it has always worked very well when
sorting. I use a Custom format of 0000, so that 0001 will show like that.

"camead" wrote:

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?