View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default Alpha-Numeric Sorting

I don't think you can change the sorting options, but if you insert your
information like this it will sort the way you want.

R01-01
R01-02
R10-01
R10-02
R10-10L
R11-01
R12-01

Another option would be to insert the information as time and use a custom
format of
R[h]-m
but you would have to change the one with the L to a custom format of
R[h]-mL
Then it would look and sort the way you want.

R1-1 - Inserted as 1:01
R1-2 - Inserted as 1:02
R10-1 - Inserted as 10:01
R10-2 - Inserted as 10:02
R10-10L - Inserted as 10:10 with secondary format type
R11-1 - Inserted as 11:01
R12-1 - Inserted as 12:01

"Jose" wrote:

The ascend sort return my list as:
EXCEL SORT WOULD PREFER THIS
R10-1 R1-1
R10-10L R1-2
R10-2 R10-1
R1-1 R10-2
R11-1 R10-10L
R1-2 R11-1
R12-1 R12-1

I would prefer the sort from the second column. The second column was
assembled manually.