右键-单元格格式-选择日期
=TEXT(DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2)),"yyyy/mm/dd")&" "&TEXT(TIME(MID(A1,9,2),MID(A1,12,2),RIGHT(A1,2)),"hh:mm:ss")
