Insert a column near to that and apply a formula; copy that down

=A1+0

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


"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