Microsoft Excel
Microsoft Excel cannot display dates before the year 1900, although this is not due to a two-digit integer being used to represent the year. Excel uses a floating point number to store dates and times. The number 1.0 represents January 1, 1900 (or, in Excel for Mac, January 1, 1904). Numbers smaller than this display as a #VALUE! error.
In addition, Excel incorrectly regards 1900 as a leap year and allows February 29 to be entered as a date in this year. This is for compatibility with Lotus 1-2-3 which also had this bug.
Read more about this topic: Year 1900 Problem
Famous quotes containing the word excel:
“All human excellence is but comparative. There may be persons who excel us, as much as we fancy we excel the meanest.”
—Samuel Richardson (1689–1761)