converting a text column to a number column & removing the '
 

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?

converting a text column to a number column & removing the '
 

--Copy a blank cell.
--Keeping the copy select your data range
--Right clickPasteSpecialselect 'Add'Click OK

If this post helps click Yes
---------------
Jacob Skaria


"Gayle from CyberCore" wrote:

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?

converting a text column to a number column & removing the '
 

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?