|
|
Excel X and Excel XP
|
|
|
|
Forum Regular
Join Date: Sep 2001
Status:
Offline
|
|
Hi guys
Please help me with this:
When I create a sheet with dates in Excel v.x, send it to my PC through SMB, copy and paste it to another sheet created in Excel XP, the dates become 1997 instead of 2001 as I had previously entered. What's going on? Now my sister is pissing me off about Mac's being incompatible with PCs . Thanks!
|
|
|
|
|
|
|
|
|
Forum Regular
Join Date: Sep 2001
Status:
Offline
|
|
|
|
|
|
|
|
|
|
|
Mac Elite
Join Date: Dec 2001
Location: Paris, France
Status:
Offline
|
|
The base date in excel tables is different on a PC and on a MAC... don't remember why
What you have to do is make a save as in any PC version (the newest possible)
That should work
Hit your sister for me
|
|
|
|
|
|
|
|
|
Mac Elite
Join Date: Mar 2001
Location: somewhere in ohio
Status:
Offline
|
|
Yeah the MacBU has done a great job with keeping formats the same with all versions of the PC office...blame M$ for their fault on not on updating their excel engine.
|
|
|
|
|
|
|
|
|
Forum Regular
Join Date: Sep 2001
Status:
Offline
|
|
Thanks for all your replies!
|
|
|
|
|
|
|
|
|
Fresh-Faced Recruit
Join Date: Nov 2001
Location: Stratford, Ct
Status:
Offline
|
|
You can fix this problem easily. The files ARE compatable between PC and Mac, the difference is the starting date on your machines. Remember the date is stored as the number of days after a specific date. For some reason, in Excel you can choose the beginning date to be either 1900 or 1904. Your excel is set to use 1904 as the starting date and your sister has it set to 1900. When you exchange files the number is the same, but because the starting point is differnt, you will get different results!
To change, go to prefrences in Excel, click on calculation, then check off 1904 date system. Only problem is that this will change all the dates of all files previously created under the old system! However, any file you create now will work with your sisters machine.
hope this helps.
|
|
|
|
|
|
|
|
|
Forum Regular
Join Date: Sep 2001
Status:
Offline
|
|
Thank you very much! That solve the problem! Is there a reason why M$ put such a disparity in the two versions? What's the 1904-system in the first place? Once again, thank you soo much!
[edit: does anyone know if the PC-versions are set to use 1904 or non-1904 date systems by default? thanks!]
[ 01-06-2002: Message edited by: scarab ]
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forum Rules
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|