View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Moonray80
 
Posts: n/a
Default Sorting Numbers w/Aplha Suffix

Is there any way to properly sort a series of numbers with an alpha suffix?
Example:

92001
92001A
92001B
91005

I've tried to convert the numbers to text but the alpha suffix nubers still
end up in a separate group.