Thread: change date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Oldjay
 
Posts: n/a
Default change date

I have a list with dates
8/18/05
I want to change them to 8/18/06
I tried using the find and replace
i.e. find ?/?/2005
replace ?/?/2006
it finds the cells but replaces with ?/?/2006
What do I put in the replace to leave the month and day alone?
oldjay