View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lee D
 
Posts: n/a
Default How do I change the year in a range of cells

I am updating this years schedule spreadsheet to next years. Since the
"scheduled" date is the same from one year to the next I only need to change
the year from 2005 to 2006. Is there a way I can do this for all of the
cells in a column?

Thanks in advance for any suggestions.

Lee