Use this in a new column to convert all zip codes to
text, and then sort on this new column:

=TEXT(IF(ISERROR(FIND("-",A1)),A1&"-0000",A1),"00000-
0000")

If the zip codes are all 5 digits (ie not in ZIP+4
format), use:

=TEXT(A1,"00000")

HTH
Jason
Atlanta, GA


-----Original Message-----
I have a sizable worksheet (6,000 rows by 10 columns),
which includes
names, addresses, and zip codes. When I try to sort on
zip codes, the
worksheet sorts in two sections vertically, in ascending
order. I
believe that is because some of the zip codes are
formatted as values
and others are formatted as text. Even so, I have tried
to format the
zip code column as text and it has not helped. So I'm
wondering what I
need to change in the zip code cell formatting to make
the proper sort
possible. Many thanks for suggestions.

.