Did you notice if the figures in the unsorted cells were entered with
leading apostrophes? That forces Excel to treat the entries as text
regardless of the cells' underlying format.

Re-entering a number without the apostrophe would fix the problem.