Editing Year

G

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.
 
B

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)
 
Top