With your present dates in K1:K500, use a helper column , say column J and
put this formula in J10 and copy down.........then do Copy PasteSpecial
Values on column J and then copy and paste it over to column K to replace
your dates without the apostrophe.

="'"&MONTH(K10)&"/"&DAY(K10)&"/"&YEAR(K10)

Vaya con Dios,
Chuck, CABGx3


"Jeff" wrote in message
...
I need help to run a formula that would replace the value of the cells
K10:K500 by adding an apostrophe ' in each row in column K

Example row K9: is 01/20/2005 needs to be '01/20/2005.

Regards,