This is from a reply by Gary''s Student to a similar question:

Select the cells in question and run:

Sub quote_killer()
For Each r In Selection
If r.PrefixCharacter = "'" Then
r.Value = r.Value
End If
Next
End Sub

If you are new to macros, this link to Jon Peltier's site may be helpful:
http://peltiertech.com/WordPress/200...e-elses-macro/

Hope this helps,

Hutch

"Ward" wrote:

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