if you have numbers being treated as text, select the entirecolumn and
format as General, then do Data=>Text to columns, select delimited, and
click OK. (if you have commas in your data, select a delimiter like # that
doesn't exist in the data).
This should cause you data to be reevaluated.
< XXXX@XXXXX.COM >