Editing Year

  • Thread starter Thread starter Gary
  • Start date Start date
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.
 
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)
 
Back
Top