Check out the settings at ToolsOptionsCalculation.

It sounds like you have "1904 date system" checked.

Uncheck it.

More on dates at Chip Pearson's site.

http://www.cpearson.com/excel/datetime.htm#SerialDates


Gord Dibben Excel MVP

On Tue, 20 Sep 2005 07:09:04 -0700, "DA" wrote:

I have a share file that shoes the dates in the year 2005. When I copy the
file, the dates change to 2001. What is causing the change?