Dates change to prior year when page moved to new book

D

David_UCSF

Excel 2003. I have columns containing dates in 2004 and 2005. When I move or
copy the page to a new book, all of the dates change to 2000 and 2001. How do
I correct so that the page can be moved or copied?
 
N

Niek Otten

Tools>Options>Calculation, make sure that "1904 date system" is the same in
both books
 
Top