oldjay

Just replace the 2005 with 2006.

Excel is smart enough to make the change.

For experiment try this.

Format 8/18/05 as dddd and returns Thursday

Now change 05 with 06.

The dddd will change to Friday which is 8/18/06


Gord Dibben Excel MVP

On Thu, 15 Dec 2005 13:06:12 -0500, "Oldjay" wrote:

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