六位數 加年月 (13699)

C2=SUBSTITUTE(TEXT(B2,"0年00月"),"年0","年")

D2 (定義 yyy年m月)=TEXT(B2,"0-00")*1

C2另解=LEFT(B2,4)&"年"&RIGHT(B2,2)/1&"月"