右键，设置单元格属于，日期，选 2010-01-02格式
=text(a1,"#-00-00")
=TEXT(DATE(LEFT(C13,4),MID(C13,5,2),RIGHT(C13,2)),"yyyy-mm-dd")
