3 easy ways to fix Excel date formats/ sorting not working скачать в хорошем качестве

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