Date Cell Corruption

J

Jenny_Kniese

Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC I have found a "bug" in the new excel which means if I copy and paste a date or date range, from an earlier version of Excel (ie an older spreadsheet), the date in the 2008/new excel changes to a date 4 years and 1 day more than the original date. Even if I try to link the cells between new and old excel, the returning date value is incorrect. Does anyone know how to fix this???? HELP!!!
 
C

CyberTaz

Sorry to burst your bubble :) but you haven't discovered a bug. What you've
discovered is that there are 2 different Date Systems used by personal
computer software. Excel can use either of the 2.

This is something that many users are not aware of because the Date System
is workbook specific, so as long as you open & work within a workbook you
have no need to be aware of which date system it uses. Likewise, if you copy
from one workbook & paste to one that uses the same dates system you won't
notice anything different.

However, if you copy from a file that uses one system & paste to one that
uses the other date system the pasted dates will be off by 4 years & one
day. For more on the well documented matter see:

 http://support.microsoft.com/kb/214330/en-us?spid=2513&sid=global

HTH |:>)
Bob Jones
[MVP] Office:Mac
 

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

Top