Make sure the cells containing the zip codes are formatted as text.

--

Vasant

"Martha Parsons" <Martha wrote in message
...
Nine digit zip codes do not sort properly in Excel even when the cell is
formatted as "Special". I use Excel to sort for mailing labels and cannot
use 9 digit zipcodes because of the error. Help!