If a date is stored as text in A2 having this format (eg. 20180624) you can convert it to a date format using:
- =DATE(LEFT(A2,4),MID(A2,5,2),RIGHT(A2,2))
Of course, you can use text to columns to get the data as date:
1) Select Delimited
2) Use Other as Delimiter but do not add any letter
3) Select Date, YMD and the destination
