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