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

来源:百度知道 编辑:UC知道 时间:2024/06/16 02:43:26
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")