date incompatibility from 2004 to 2008

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
 
M

michgal

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
Click to expand...

I figured this out - if i go to preferences and Uncheck the Calculation Use the 1904 date system checkbox it now shows correctly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

datse copied from excel 2004 to 2008 are incorrectly formatted 1
Where is the lasso feature in 2008? (was informatting palette in 2004) 4
Running Excel 2004 & 2008 on the same computer 7
Excel 2008 running very slowly - OS 10.5.8 8
2008 charts are resized in 2007 4
Pasting pictures between Excel 2004 and Powerpoint 2008 4
2004 and 2008 2
Excel 2008 crashing when saving 2

Top