Question: how to convert yyyymmdd to normal date format in excel?
Answer: Step 1: Extract the year. =LEFT(A1,4) => 2018.
Step 2: Extract the day. =RIGHT(A1,2) => 25.
Step 3: Extract the month. ... 
Step 4: Convert each part as a date.