Find/Replace Date Question

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Using Excel 2003.

Problem replacing a series of dates having a date format of dd/mm/yy. I want
to replace all dates ending with /05 with /06. I enter in the Find box /05
and in the Replace box /06

Error is "Microsoft Office cannot find a match"

I never had this problem with earlier versions of Excel.

TIA

Jim
 
Check the cell contents of one of the cells (in the formula bar)....

Is the date like: 1/1/05
or (more likely)
is it like 1/1/2005

If the latter, then find /2005 and replace it with /2006

Does that help?

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

XL2002, WinXP-Pro
 
Back
Top