Converting ISO 8601 date format in Excel
Posted: Wed Jul 15, 2020 7:03 am
I would greatly appreciate guidance as to how to convert Everything's ISO 8601 date format to any of the date and time formats in Excel 2016. I notice that the date and time data Everything yields is 18 digits long. I've seen suggestions elsewhere on the web and tried several suggested formulas but without any success. Thanks in advance for any assistance.