excel 日期如何改 急06.3.12-07.2.20改成20060312－20070220

A1是数据，那么你在B1中输入公式
=TEXT(SUBSTITUTE(LEFT(A1,FIND("-",A1)-1),".","-"),"yyyymmdd")&"－"&TEXT(SUBSTITUTE(20&RIGHT(A1,LEN(A1)-FIND("-",A1)),".","-"),"yyyymmdd")

你试试看

假设数据在A列，在B1输入公式：
=TEXT(SUBSTITUTE(LEFT(A1,FIND("-",A1)-1),".","-"),"emmdd")&"-"&TEXT(SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("-",A1)),".","-"),"emmdd")