View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Dave

i think you'll find it has something to do with the 1900 or 1904 date system
.... i don't know anything about Macs but if you have a look on your windows
machine under tools / options / calculation - there's a tick box for the
1904 date system ...
by default it is unchecked - but i'm guessing this is what is causing the
problem.

happy hunting

Cheers
JulieD

"dlg1967" wrote in message
...
I am at a loss to explain this one and need help to try to resolve. I have
a
workbook that was created on a Macintosh and I put the date September 1,
2004
in a cell. I copy the file to a Windows machine and the date shows up
correctly. On the Windows machine, I open a new workbook and copy the date
to
the new workbook. The date now changes to October 30, 2000.

What I have found is that Excel for the Mac has a different number in the
cell (I call it the date offset but do not know what it is really called).
The number in the workbook created on the Mac is 36796, where on Windows
the
date has the number of 38231. Since the date showed up correctly in the
workbook created on the Mac when I opened it on Windows, I assume this
offset
is stored in the workbook. I created a new spreadsheet in the original
workbook on the Windows machine and the date shows up correctly, so that
proved my theory.

Are these offsets supposed to be different? If not, how can I resolve
this.
I have Office XP for Windows and Office 2001/Office X for the Mac (OS9 and
OS
X). Any ideas?

Thanks much
Dave