假设"Sep 20 2014 12:00AM"写在A1单元格则B1单元格写入公式=TEXT(MID(A1,FIND(" ",A1)+1,2)&"-"&LEFT(A1,FIND(" ",A1)-1)&"-"&MID(A1,FIND(" ",A1,FIND(" ",A1)+1)+1,4),"e年m月d日")
