Even though the dates display as 8/18/06...if you check the formula bar,
you'll see that that date is actually 8/18/2006. So, try this:

Select your date range
EditReplace
Find what: /2005
Replace with: /2006
Click [Replace All]

Does that help?

***********
Regards,
Ron


"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