Thread: change date
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Laura \( '_' \)
 
Posts: n/a
Default change date

Ctrl -H

Replace 05 with 06

Ok

:o)

--
@---}--
Laura..... :)
Liverpool, England

"Oldjay" wrote in message
...
: 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
:
: