3 easy ways to fix Excel date formats/ sorting not working

Three quick ways to fix dates in Excel where they don't allow you to change format, sort or give #VALUE errors when you are trying to work with them. Includes how to convert 8 digit number to a date in Excel e.g. 25122018 to 25 December 2018.

------------------------------------------------------------------------------------------------------------------------------------------------------

✅- Free check of your Excel Skill Level- https://excel-skills-assessment.com/s...
🏅- Test employee Excel skill levels- https://excel-skills-assessment.com/e...
🏆- Improve you Excel Skill Levels- https://online-excel-training.auditex...
🇿🇦- Our main website- https://www.auditexcel.co.za/blogs/

------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps

00:00 Fixing Excel where it is not recognizing date formats
00:11 Check to see which dates are recognized and which are not
00:30 Day Month Year versus Year Month Day in on different computers
00:40 Excel function to make Excel recognize dates (1st thing to try)
01:01 DATEVALUE not working- #VALUE error
01:54 Use Excel AI to make Excel recognize date formats (2nd option)
02:35 Date format of yyyymmdd (long number)
02:55 Excel date #### error
03:18 Fix yyyymmdd date format with Text to Columns (3rd option)
04:16 Fix mm/dd/yyyy format with Text to Columns
04:54 Fix yyyy.mm.dd date formats in Excel
05:18 Formula options for date format when DATEVALUE not working