View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tab Tab is offline
external usenet poster
 
Posts: 11
Default sorting problems

HOT WATER HEATER:50766-1
HOT WATER HEATER:50766-10
HOT WATER HEATER:50766-2
HOT WATER HEATER:50766-3
HOT WATER HEATER:50766-4

This is the data that I am trying to sort by. The item with a -10 should be
at the end but it always comes up this way.

Please help. All of the postings that I looked at have not helped.

Thanks,