HI,
highlight the column, CTRL H, value to find enter ' replace with leave blank

hope this helps

"Soth" wrote:


Hi-

In a cell consist of this number '24110100, I did try copy and paste special
trying to get rid of this apostrophe " ' " in front of number and I'm not
able to do so. The other way is to delete it, but I have thousands of
numbers. Is there a better way to get rid of this apostrophe ' sign?

Thanks,
Soth