datse copied from excel 2004 to 2008 are incorrectly formatted

M

michgal

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Please help
I am copying data from an excel 2004 worksheet to a new excel 2008 worksheet. A date entered as 8/1/2006 and formatted as 8/1/06 shows in a new 2008 worksheet as 2/2/10. I have updated all updates and am running 12.1.4
 
J

JE McGimpsey

I don't think your examples are correct, because the problem is
undoubtedly that you have the "1904 date system" checkbox checked in the
XL04 workbook's preferences (Preferences/Calculation), but not in your
XL08 workbook.

That causes a 4 year and 1 day shift (the 1 day is related to the 1900
system's erroneous inclusion of the fictitious 29 February 1900). So

8/1/2006

should display as

8/2/2010

or

9/1/2010

depending on whether you're using mm/dd/yyyy or dd/mm/yyyy.
 
Top