Jeff Jonas on 9 Feb 2004 05:23:36 -0000


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

Re: Fwd: Excel Annoyances Needed for New Book [OT]


> O'Reilly is pulling together a new book called "Excel Annoyances" and
> we'd like your help!

I once worked on a project importing and exporting EXCEL data
in Comma Separated Format.

There is an oddity with date conversions, already noted in
    http://www.j-walk.com/ss/excel/odd/odd02.htm
    http://www.cpearson.com/excel/datedif.htm
    http://www.codeproject.com/datetime/exceldmy.asp

Lotus 123, Excel and others think that 1900 was a leap year,
so "60" is Feb 29.1900 which does not exist.
-
**Majordomo list services provided by PANIX <URL:http://www.panix.com>**
**To Unsubscribe, send "unsubscribe phl" to majordomo@lists.pm.org**