Better Way to Convert ISO Date YYYYMMDD to Excel Date: TEXT Function Hack! Excel Magic Trick 1896

Download Excel File: https://excelisfun.net/files/EMT1894-...
Learn how to use the TEXT function and Social Security Number Custom Number Formatting to convert ISO text dates back to dates that can be used in date formulas, functions and calculations.
Topics:
1. (00:00) Introduction.
2. (00:01) ISO Dates
3. (00:10) No Power Query
4. (00:17) No LEFT, MID and RIGHT function combo in the DATE function
5. (00:31) TEXT Function with Social Security Custom Number Formatting
6. (01:46) TEXT Function with Spilled Results
7. (02:00) Summary & Closing

#excel #microsoft #excelisfun #excelcourse #text #textformulas #textfunction #isodate


#excel #excel365 #excelisfun #highlinecollege #mikegirvin #freeexcellessons #excelformulas #excelfunctions