Excel Tricks - Change dates like 20160923 to one Excel can "understand"

 

Step – 1 Select the date(s),

Step – 2 Click Data tab, Text-to-Columns

Step – 3 Which brings up the Text-to-Columns wizard

Step – 4 Even though the dates are fixed width, in this case you can simply click "Next" twice. In step 3 of wizard Select Date, YMD:

Step – 5 See the result below:-

Please watch this video and share your feedback

***********************************************************************************