Byg Software

016
 
How do I convert these numbers to dates? 
20020820
20020920
20021020
20020821
20020901
20021011
Do Data > Text to columns,
Click Next
Click Next
On the upper right hand side it says "Column data format", check the option that says Date
In the scroll down select YMD (to describe the current format in the cell)
Click Finish..
 
You may then need to do a Format > Cells to get the format you require.
 
Close