LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
dlg1967
 
Posts: n/a
Default Date issue between Windows and Macintosh version

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to open in windows a macintosh excel file macmai Excel Discussion (Misc queries) 6 January 8th 05 12:44 PM


All times are GMT +1. The time now is 08:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"