Then all you have to do is
Format cells-Custom-Write e/mm/dd aaaa or YYY/MM/DDAAAA in the type, which is displayed as.
Tuesday, April 24, 1965
Otherwise, we must write the formula in cell B 1
=IF(A 1= ""，" "，TEXT(RIGHT(A 1，4)& amp； “/”& amp； LEFT(A 1，2)& amp； “/”& amp； MID(A 1，4，2)，" aaaa "))
Drop-down filling formula