FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -These numbers are known as serial values or serial numbers. The reason dates are stored as serial numbers is to facilitate calculations. In the 1900 date system, the first date that Excel recognizes is January 1, 1900. This date is stored as the number 1 in Excel.

Detailed explanation-2: -In the 1900 date system, dates are calculated by using January 1, 1900, as a starting point. When you enter a date, it is converted into a serial number that represents the number of days elapsed since January 1, 1900. For example, if you enter July 5, 2011, Excel converts the date to the serial number 40729.

Detailed explanation-3: -Unfortunately, Excel’s serial number begins on January 1, 1900; and negative serial numbers aren’t recognized. (The default date for the Macintosh is 1904. To change the default date, choose Tools, Options, select the Calculation tab, and then select or clear the 1904 date system checkbox.)

Detailed explanation-4: -A cell with 1/0/1900 has a format of Date not General. Or the value in the cell is not a proper date. If a cell has the value 0 and is formatted as a Date then it will show as 1/0/1900 since this has the value 0 on the Excel date system.