2401111245变换24.01.11 12:45
=left('2401111245',2)+'.'+mid('2401111245',3,2)+'.'+mid('2401111245',5,2)+' '+mid('2401111245',7,2)+':'+right('2401111245',2)
CONCATENATE(LEFT($$$,2),".",MID($$$,3,2),".",MID($$$,5,2)," ",MID($$$,7,2),":",RIGHT($$$,2))
MID(FORMAT(TODATE(CONCATENATE("",2401111245),"yyMMddHHmm"),"yyyy.MM.dd HH:mm"),3,50)
你可以把上面2401111245换成单元格地址,类似如下
MID(FORMAT(TODATE(CONCATENATE("",a2),"yyMMddHHmm"),"yyyy.MM.dd HH:mm"),3,50)