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:
“There are portraits and still-lifes
And the first, because ‘human’
Does not excel the second,”
—Charles Tomlinson (b. 1927)