MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


Posted by iml on September 26, 2001 2:32 PM

3

Your number are being treated as text.
Highlight the column and goto data - text to columns.
Hit finish and now sort them.

Good luck 3