Hi
I'm having a heck of a time soring some simple numbers, can anyone help? This is what I'm try to do. The first set of numbers is how excel sorted these numbers. But I want them sorted as in the second set of numbers. Use the ascending button will get you the first set. I don't know how to get all the 1's together and then all the 2's next ans so on reguardless of the number of digits.
Thank you in advance for any help anyone can give me.
1 -------- 1
2 -------- 11
3 -------- 111
11 ------- 2
22 ------- 22
33 ------- 3
111 ------ 33
:thanx: