Use the Sort feature... Data-Sort. Make sure both your Zip 5 and Zip 4
columns are selected. Then, in the first box titled "Sort by" choose the
column with the Zip 5. Then, in the second box titled "Then by" choose the
Zip 4 column. This will wort the Zip 5 followed by Zip 4. You can choose
either Ascending or Descending.
--
Regards,
Dave


"Libby" wrote:

We have an excel spread sheet that has one column which contains zip codes.
About 60% of them are Zip +4 but the rest of them are only 5 digit zip codes.
When we want them to sort so they sort by the first five digits only. It
would be nice if the next 4 were in ascending order also but not necessary.
Any Ideas?
--
Libby