Sorting Question

[G@ines63]

Hello All,
I am posting a question regarding the sorting of numbers in the following format:
1\1
1\2
1\3
2\1
2\2
2\3....and so on.
The issue I am having is, once the numbers reach 9\3, the numbers begin to sort as follows:
100\1
100\2
100\3...
I would like any input as to how to create a custom sort to keep the numbers in succession, i.e
9\1
9\2
9\3
10\1
10\2
10\3
11\1
11\2
11\3
12\1
12\2
12\3...and so on
Thank you in advance for any assistance.

 

[srinidhi]

I don't have a straight forward answer, but I have a workaround. Replace the \ with the . Now sought the value & again you can replace . with \

 

[vletm]

Here is almost same kind of case:
http://forum.chandoo.org/threads/sorting-decimal-values.25856/

 

[excelent]

Split the numbers up in 2 seperate columns

'=LEFT(K2,FIND("\",K2)-1)

'=MID(K2,FIND("\",K2)+1,9)

Then sort all 3 columns after columns vith the first digit then the sekond digits