cmm1@cunixa.cc.columbia.edu (Christopher M Mauritz) (10/23/90)
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 |
------------------------------+---------------------------fwb@demon.siemens.com (Frederic W. Brehm) (10/24/90)
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
aslakson@cs.umn.edu (Brian Aslakson) (10/24/90)
fwb@demon.siemens.com (Frederic W. Brehm) writes: >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). 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? (I know more about MacDates than I ever wanted to know thanks to backing up files from the year 2040 over and over and over again -- by the way, a script in MPW did the trick, but is there a program out there that will sweep thru a hard drive and set dates (hopefully dates by my parameters to dates by my parameters),(and hopefully under AppleShare)????) Brian Aslakson 2040 is the answer to next weeks quiz.
fwb@demon.siemens.com (Frederic W. Brehm) (10/24/90)
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
boris@world.std.com (Boris Levitin) (10/25/90)
aslakson@cs.umn.edu (Brian Aslakson) writes: >fwb@demon.siemens.com (Frederic W. Brehm) writes: >>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). >(I know more about MacDates than I ever wanted to know thanks to backing up >files from the year 2040 over and over and over again -- by the way, a >script in MPW did the trick, but is there a program out there that will >sweep thru a hard drive and set dates (hopefully dates by my parameters >to dates by my parameters),(and hopefully under AppleShare)????) Norton Utilities for the Mac fixes file creation & modification dates that don't make sense.