Sorting numbers... correctly

I am working from a spreadsheet (XL2003) dumped from the BOM of a CAD program. I'm having trouble sorting numbers, Excel wants to sort them 1, 10, 100, 2, 20, 200.... (as an aside, is behavior this a candidate for "Most Moronic Microsoftism?) The first thing I do when working with the BOM spreadsheet is make a column at the beginning and number the cells, this is so I always have a reference to re-sort the BOM in the order it was originally dumped from the CAD, and, weirdly, THIS column always sorts in numerical order...???? I've formatted the column that's acting wonky as numbers, but to no avail. How do I teach EXCEL to COUNT???

Here's a .xls with the offending column. I formatted it as Number, but it didn't help. I had the decimals set to 2-place, but the "numbers" didn't change, so I think they're not really numbers (just pictures of numbers??). If they are text, where do I choke EXCEL to make them numbers? Thanx.

Where is "Text To Columns"??

got it!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!