Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick145.xlsx

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
See Mr Excel and excelisfun convert YYYYMMDD Numbers To Dates:
1. Text To Columns
2. Formula with DATE, LEFT, RIGHT, MID functions
3. Flash Fill
4. Text Function with custom Number Format 0000\/00\/00