Not sorting properly - not sorting from right to left
Posted by Lisa on September 26, 2001 2:13 PM
I have a series of numbers where Excel is sorting by the 1, 10, 100's place (left to right) instead of right to left in ascending numeric order. I have tried the cell format as "general" and as "number", have tried sorting with and without header row checked, and I still get weird results. No formulae are in the cells. For example, this is how Excel sorts the following - picking up the first number on the left:
1
12
150
2
23
45
467
instead of
1
2
12
23
45
150
467