You could try this short-cut method - highlight the column with the
offending "numbers". Click Data | Text-to-columns and in the panel that
pops up just click Finish.

Hope this helps.

Pete

Evan wrote:
We get spreadsheets from another application that have a column of "numbers"
that act like text. The only way to get them to act like numbers is to copy
them out to a text file and then copy them back in. Is there an easier way?