There are two date systems in Excel: the "normal" system (default in Windows
systems) and the "1904-system". The latter is used on Mac systems.
On a Windows system: check your date system in ToolsOptionsCalculation.

--
Kind regards,

Niek Otten

--
Kind regards,

Niek Otten

"kathryn" wrote in message
...
My list of dates is changing when I copy sheet from original workbook to
new
workbook. For ex, 02/06/2006 changed to 02/07/2010. How can I fix this?