00:00Why are dates shown as a very large number? When you enter a date and convert the cell format to
00:05general, it shows a large number in the scale of 45,000 at the time of this recording. The number
00:11you see in the unformatted column is the number of days elapsed since 1st January 1900. Say for
00:18example, if you put number 1 here, you get 1st January, and if you put number 2 here, you get
00:232nd January, and so on. From this, you can see Excel stores date as sequential serial number starting
00:30from January 1st, 1900, which can be handy in multitude of applications. So this number here
00:35is 45,518 days since 1st January 1900. Likewise, if you enter 45,111 and change the cell formatting
00:44to date, you get 4th of July, 2023.