Skip to playerSkip to main content
Learn how why are my dates showing as numbers in Excel?

Why are my dates showing as numbers in Excel?,What is the date 44562 in Excel?,How to do long date number format in Excel?,How to turn dates into numbers in Excel?,How do I get Excel to stop changing my dates to numbers?,How do I fix the date format in Excel?,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://thao.funnymoment.net/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Category

📚
Learning
Transcript
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.

Recommended