Let us first determine if the entries are text or formatted dates.
If the fist date is in A1 what does the formula =ISNUMERIC(A1) return?
If TRUE then all you need do is reformat the cells
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"NotGood@All" wrote in message
...
I have inherited a workbook that has some columns where the person entered
the date as 5/21, 6/10.. All the dates are 2007. Is there a way for me
to
add "2007" to each of the rows so the date appears as "5/21/2007"
--
NotGood@All