How do I sort by the first digit of a number?
I'm trying to sort a list of part number like this:
10, 54, 94, 101, 1800, 200, 2000, 500
The only way I can find to sort them is:
10, 54, 94, 101, 200, 500, 1800, 2000
What I need is them sorted by the first digit and then the entire number:
10, 101, 1800, 200, 2000, 54, 500, 94
Is there any reasonable way to do this without manually creating another
column that has the first digit in it?
Any help would be greatly appreciated.
|