Path: utzoo!attcan!uunet!wuarchive!zaphod.mps.ohio-state.edu!usc!ucsd!rutgers!njin!princeton!siemens!demon!fwb
From: fwb@demon.siemens.com (Frederic W. Brehm)
Newsgroups: comp.sys.mac.misc
Subject: Re: Weird Excel behavior
Message-ID: <42993@siemens.siemens.com>
Date: 24 Oct 90 14:46:10 GMT
References: <1990Oct23.152734.8102@cunixf.cc.columbia.edu> <42898@siemens.siemens.com> <1990Oct24.004033.4941@cs.umn.edu>
Sender: news@siemens.siemens.com
Organization: Siemens Corporate Research
Lines: 18

I wrote:
>Excel thinks "1/2" is a date entered without the year. 1/2/1990 is 31413
>days after day 0 (whatever that was, figuring this out is left as an
>exercise for the reader).

(Brian Aslakson) responds:
>You mean exercise in finding the answer in a horrible manual set, or, an
>exercise in simple math taking far less time to figure it out?

To which I reply:
Sorry, you fail the exercise.  Use Excel.  Enter 0 in a cell, then change
to a date format.

Better luck on the next quiz. :-)
Fred
--
Frederic W. Brehm	Siemens Corporate Research	Princeton, NJ
fwb@demon.siemens.com	-or-	...!princeton!siemens!demon!fwb