That is because your numbers are defined as texts, so it sorts them
"alphabetically".

A trick to convert "text numbers" to numbers:

1. Write in some cell the value 1.

2. Copy that cell (press on it Ctrl+C).

3. Select all your numbers that are mistakenly considered as texts.

4. Go into "Paste special" (if it is in older versions of excel it is
through the "Edit" menu. In Excel 2007 it is through the small arrow under
the "Paste" button).

4. Select the "Multiply", and click "OK".

5. Thats it! All the numbers, are now converted to become real numbers.

Good luck!

http://www.free-training-tutorial.com




"JoAnn" wrote:

Hello,

I have a coworker who did a filter on her spreadsheet (so the blanks were
not visable) and then did a sort ascending by the sequence number. What she
got was a sort that was like this: 1, 10,100,1000, 491, 3, and so on. What
the heck is going on?!?