Dates change to prior year when page moved to new book
 

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?

Dates change to prior year when page moved to new book
 

ToolsOptionsCalculation, make sure that "1904 date system" is the same in
both books

--
Kind regards,

Niek Otten


"David_UCSF" wrote in message
...
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?