View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JWCrosby JWCrosby is offline
external usenet poster
 
Posts: 6
Default mixing zip with zip+4 and then sorting

I have a zip code column that has both standard zips (5 digits) and zip +4
(00000-0000). When I sort by zip it sorts all the 5-digit zips separately
(at the beginning) from the zip+4. How can I get it to sort and mix them
together in proper order?