select column then use data/text to columns
click next/next
check date and choose ymd option
click finish