Thread: Sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Slim Slender Slim Slender is offline
external usenet poster
 
Posts: 4
Default Sorting

I think it's reasonable to want the following items sorted in the following
order:
170B
424
439A
628
731
735
D08
D15

and, in fact, that's how I need them. However, Excel insists on putting them
in this order, which is rather scrambled but somewhat logical:
424
628
731
735
170B
439A
D08
D15
It appears to be sorting numbers first and then anything that contains an
alpha (treating digits as letters). Is there a way to get the first sort
order?