👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
[ Ссылка ]
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
------------------------
