Simply opening and closing TTC (Text To Columns) will correct the problem:

Select the column of data, then, from the Menu Bar:

<Data <TextToColumns <Finish

And you're done!
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"Gayle from CyberCore" <Gayle from
wrote in message ...
I have a large spreadsheet with a column of information that was set up as
text even though the contents are numbers.
I want to highlight the whole column and perform a function that will
eliminate the ' before each number.

Can that be done?