Excel英文时间转换成中文时间问题答:原始数据在A1,先在C1输入:=SUBSTITUTE(A1," ","")再在B1输入:=TEXT(DATE(RIGHT(SUBSTITUTE(A1," ",""),4),CHOOSE(FIND(1,(IF(ISNUMBER(VALUE(LEFT(C1,2))),MID(C1,3,3),MID(C1,2,3))="Jan")*1&(IF(ISNUMBER(VALUE(LEFT(C1,2))),MID(C1,3,3),MID(C1,2,3))="Feb")...