Sorting numeric and alphanumeric data

I have a list that contains both numeric and alphanumeric data (see attached file). I want to sort anything that looks like a number as a number. I know i used to be able to do this in Excel 2007, but can't figure out why it doesn't work in the 2010 version.

Any help would be greatly appreciated.

Thanks Scott

There used to be a pop up window or option when you click the Sort button, then you could select to sort anything that looks like a number as a number. But i don't see it in the 2010 version. Maybe they got rid of that option.

I finally figures out where that pop-up window is, and now it works. It was actually the "sort numbers and numbers stored as text separately" option. I hope the boss doesn't find out i spent most of the day trying to sort a spreadsheet. LOL.

Thanks

Click DATA, SORT, then OPTIONS. Check the Case Sensitive option. Then click OK twice. A Sort Warning pop-up window will appear. Select the "sort numbers and numbers stored as text separately" option.


FYI: a couple of thing you need to do first.
1. The column should be formatted as TEXT. I don't know if it's necessary, but i think it makes things easier.
2. If you already have numbers entered, you will need to re-enter them to convert it to actual text. In the formula bar you should see a apostrophe in front of the number (example '12345).


I attached a condensed sample spreadsheet so you could see the actual entries. Since all the data in column A is actually text, it sorts exactly like how i wanted.