How to convert yyyymmdd in excel as date?

Report Form

• Question has grammatical errors or is not meaningful, need correction!
• Topics list is not appropriate, need correction!
• Question already exists, need merge with old one!
• Question hurts sentiments, remove this question!
• None of the above!

Paste old question below.