非日期格式改可計算格式 (14084)

C2=REPLACE(B2,4,2,TEXT(MID(B2,4,2)&-1,"MMM"))*1

另解=DATE(RIGHT(B2,4),MID(B2,4,2),LEFT(B2,2))

另解=RIGHT(B2,4)&-MID(B2,4,2)&-LEFT(B2,2)

月日單數字 可=TEXT(SUMPRODUCT(MID(SUBSTITUTE(B2,"-",REPT(" ",19)),{3,2,1}*19-18,19)*10^{4,2,0}),"0-00-00")