Try highighting the column of numbers
Data - Text to Columns
Delminated - Next
UNcheck all options - Next
Choose Date - YMD
Click Finish

Format the column in a date format of your choice.