If you have found this content useful and want to show your appreciation, please use this link to buy me a beer .
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you!
In this video I answer the question: ‘Why does Excel change dates to seemingly random numbers?’
The answer is – it doesn’t! Excel assigns a serial number to each date it recognises and sometimes, depending on the function you are using, Excel will return a date as its serial number. So the number is not random, it is actually a count of days since 31/12/1899. There are two ways you can get around this problem…

Table of Contents:

00:00 – Introduction
00:33 – What are the random numbers?
01:09 – Format ‘random numbers’ as dates
01:28 – Apply custom formats to your dates
02:42 – Alternate method for converting ‘random numbers’ – using the TEXT function
————————

Please take the opportunity to connect and share this video with your friends and family if you find it useful.