Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!know!sdd.hp.com!ucsd!rutgers!cunixf.cc.columbia.edu!cunixa.cc.columbia.edu!cmm1
From: cmm1@cunixa.cc.columbia.edu (Christopher M Mauritz)
Newsgroups: comp.sys.mac.misc
Subject: Weird Excel behavior
Message-ID: <1990Oct23.152734.8102@cunixf.cc.columbia.edu>
Date: 23 Oct 90 15:27:34 GMT
Sender: news@cunixf.cc.columbia.edu (The Daily News)
Organization: Columbia University
Lines: 27

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?

I am using a MacIIcx under Multifinder, system 6.0.7, 5 megs RAM.

Any help would be greatly appreciated.

Cheers,

Chris


p.s.  Sorry for the flurry of requests.  I'm still getting the hang of
      the Mac's OS, after spending 5 years learning about the brain
      damaged TOS OS from my old Atari ST. :-)




------------------------------+---------------------------
Chris Mauritz                 |D{r det finns en |l, finns
cmm1@cunixa.cc.columbia.edu   |det en plan!
(c)All rights reserved.       |
Send flames to /dev/null      |
------------------------------+---------------------------