Re: XL: DATEVALUE("1/1/1900")

From: Neil Booth <neil daikokuya demon co uk>
To: "Andreas J. Guelzow" <aguelzow taliesin ca>
Cc: gnumeric-list <gnumeric-list gnome org>
Subject: Re: XL: DATEVALUE("1/1/1900")
Date: Thu, 20 Dec 2001 19:31:06 +0000

Andreas J. Guelzow wrote:-

Could somebody with access to XL please confirm that in XL 
DATEVALUE("1/1/1900")
evaluates to 1 ?


Yes, it's a well-known bug; they forgot about 29/2/1900.  Various
other programs have had to break for compatibility, and now that
so many sheets are broken with it, MS won't fix it.

Neil.

Follow-Ups:
- Re: XL: DATEVALUE("1/1/1900")
  - From: Neil Booth

References:
- XL: DATEVALUE("1/1/1900")
  - From: Andreas J. Guelzow

[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]