Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!wuarchive!udel!princeton!siemens!demon!fwb
From: fwb@demon.siemens.com (Frederic W. Brehm)
Newsgroups: comp.sys.mac.misc
Subject: Re: Weird Excel behavior
Message-ID: <42898@siemens.siemens.com>
Date: 23 Oct 90 19:32:07 GMT
References: <1990Oct23.152734.8102@cunixf.cc.columbia.edu>
Sender: news@siemens.siemens.com
Organization: Siemens Corporate Research
Lines: 16

In article <1990Oct23.152734.8102@cunixf.cc.columbia.edu> cmm1@cunixa.cc.columbia.edu (Christopher M Mauritz) writes:
>Is this a bug or am I doing something wrong:
>
>Open Excel (v2.2).  Set the number format to 0.00.  Now type "1/2" without
>the quotes.  Why do I get 31413.00 instead of .50?

You would get 0.50 if you typed "=1/2" (without the quotes)

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).

Fred
--
Frederic W. Brehm	Siemens Corporate Research	Princeton, NJ
fwb@demon.siemens.com	-or-	...!princeton!siemens!demon!fwb