I'm guessing they're still text becasuse Excel certainly does sort numbers
properly. Excel sorts based on the underlying value, not the format.
Numberformatting doesn't change the underlying data type, it just changes
the look of the real value.
Numbers in Excel are right-aligned by default, text is left-aligned by
default.
To convert to numeric values you can type a 1 in a cell, copy it, select the
numbers, PasteSpecial/Multiply.
--
Tim Zych
SF, CA