Very easy:


1. Highlight the cells you want to change
2. Pull-down:
Edit Find 2005 in the findwhat field
2006 in the replacefield and click replace all
--
Gary''s Student


"Lee D" wrote:

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