hello
select all those dates ( 6 digits)
go to data
- text-to-column
delimeted
choose date...
choose your kind of format MDY,YMD etc.

hth