|
[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**
|
|