Copying worksheets with dates in it

S

Sarah

I have an Excel worksheet with one column fill of dates
when I copy this worksheet to a new worksheet all the
years in the dates change to the future eg 23.12.04 will
say 23.12.07.
 
N

Norman Harker

Hi Sarah!

Check that both workbooks are using the same date system:

Tools > Options > Calculation
Default is usually uncheck 1904 Date system

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top