in each cell a ' precedes the contents ie. '01/01/1999 or 'Tuesday.

I can't find and replace the item (') as excel can not see it at the start
of the cell

I don't really want to multiply everything by 1

can you help me get rid of all the ' out of every cell

many thanks