Hi,

1. Select a blank cell and chooce Copy
2. Select all the cells you want to convert and choose Edit, Paste Special,
Add.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"amik" wrote:

I have a column of this type of text


'29372
'23232

ect. I want to a find and replace to get rid of the ' what format
does it need to be in to do this.


Adam