Forum Discussion
Errors in spreadsheet
My dates are 5 numbers and cannot change them. My dollar amounts will not add. The sum formula does nothing. How can you tell if a spreadsheet is locked?? It almost acts like it is .. I have sw...
DATE function Note: Excel stores dates as sequential serial numbers so that they can be used in calculations. January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900. You will need to change the number format (Format Cells) in order to display a proper date