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:
“This we take it is the grand characteristic of our age. By our skill in Mechanism, it has come to pass, that in the management of external things we excel all other ages; while in whatever respects the pure moral nature, in true dignity of soul and character, we are perhaps inferior to most civilised ages.”
—Thomas Carlyle (1795–1881)