![]() If you count that many days after January 1, 1900, you end up with a date in the year 26956. In Figure 1, cell A2 contains the value 9,152,015. Press Ctrl+` again to toggle back to showing the dates instead of the serial numbers. The date cells will display the serial number being stored behind the date. To see this for yourself, find any worksheet with real dates and use Ctrl+` to toggle into Show Formulas mode. For example, the date November 15, 2015, is actually stored in Excel as 42,323. The problem is that Excel stores dates as the number of days that elapsed since January 1, 1900. While the human brain can recognize that this likely means September 15, 2015, Excel does not. When I looked at the spreadsheet, the Effective Date column contained values such as 9152015. I received a worksheet from an IMA member asking why the dates in column A couldn’t be formatted into MM/DD/YYYY format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |