Editing Year

[Gary]

I have a spreadsheet that contains a large number of
dates in one column. I wish to copy this spreadsheet to
use again in 2005, but when I attempt this the year part
of the date still shows 2004. Rather than changing each
individual cell, is there an easier way to perform this.

 

[Bob Phillips]

Gary,

You can use Replace (Ctrl-H).

Just use values of 2004 and 2005.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Andy Brown]

Bob's right, but watch out for Feb 29th.

Rgds,
Andy

 

[Bob Phillips]

Lol! Good point

Bob