Re: Bug in Microsoft Excel

Article View: comp.sys.mac

Article #45503

#45503

From: Ralph Brandi
Date: Fri, 02 Feb 1990 13:41

19 lines
1156 bytes

In article <4769@utastro.UUCP> bill@utastro.UUCP (William H. Jefferys) writes:

>When reading a TEXT file with a date, Excel consistently subtracts
>4 years and 1 day from the date. Thus, a text file containing
>the date 3/10/90 will have the date converted to 3/9/86 when
>Excel reads it.

4 years and 1 day....  Why does that sound so familiar?

Could it be that the default start date for the Macintosh is January
1, 1904?  Subtract 4 years and 1 day from that and you get December
31, 1899 (or maybe midnight, January 1, 1900....)

Nah, Microsoft wouldn't be so stupid as to start counting from the
wrong day....
-- 
Ralph Brandi     ralph@lzfme.att.com     att!lzfme!ralph

Work flows toward the competent until they are submerged.

Technical Details

Message-ID: <3712@cbnewsj.ATT.COM>

Path: arc1-ca.pugleaf.net!utzoo!utgpu!jarvis.csri.toronto.edu!clyde.concordia.ca!rutgers!att!cbnewsj!ralph

References: <4769@utastro.UUCP>

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!utzoo!utgpu!jarvis.csri.toronto.edu!clyde.concordia.ca!rutgers!att!cbnewsj!ralph
From: ralph@cbnewsj.ATT.COM (Ralph Brandi)
Newsgroups: comp.sys.mac
Subject: Re: Bug in Microsoft Excel
Message-ID: <3712@cbnewsj.ATT.COM>
Date: 2 Feb 90 13:41:39 GMT
References: <4769@utastro.UUCP>
Reply-To: ralph@cbnewsj.ATT.COM (Ralph Brandi)
Organization: AT&T Bell Labs, DEIO Tech Pubs
Lines: 19

Reply to Parent Message