How to Convert Number to Date YYYYMMDD in Excel

In Excel, sometimes we take date input as a number. But later we need to convert those numbers or text strings into a date like YYYYMMDD format. That is because Excel only recognizes these YYYYMMDD ...