Serial Number and Serial Date in Excel
The serial number is calculated either manually or as a result of formulas involving date calculations. Similarly, in the 1904 system, the number 40908.5 represents 12 p.m. on January 1, 2016. For example: Only one date system can be used per workbook. Pongsak Tawansaeng / Getty Images Except in Excel 2007, where you select theOfficebutton. SelectOptionsto fire up the Excel Options dialog box. SelectAdvancedin the left-hand panel of the dialog box....