This code will do it: paste this in as a macro, then highlight the
range of dates in question and run.

Sub Add_Apostrophe()
Dim rCell As Range

For Each rCell In Selection.Cells
rCell.Value = "'"& rcell.value
Next rCell
End Sub