View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
baha baha is offline
external usenet poster
 
Posts: 12
Default sorting problems

On Feb 18, 11:25*pm, tab wrote:
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,


If you try to add 0 at the beginning of single denomination should be
no problem.like as, istead of 1 need to put 01.
cheers
Baha