You could try =VALUE(celladdress) followed by Paste Special.

"Susana Conklin via OfficeKB.com" wrote:

Hi,

I have a database with over 14400 lines of info that I need to delete the apostrophe before the value, to make it a value, how do I do this?

--
Message posted via http://www.officekb.com