非日期格式 改民國年格式 (15033)

E3=RIGHT("000"&TEXT(RIGHT(C3,4)&"/"&LEFT(C3,LEN(C3)-5),"E/mm/dd"),10)

E3另解=RIGHT(TEXT(MID(C3&"/"&C3,LEN(C3)-3,LEN(C3)),"!0!0!0e/mm/dd"),10)

F3前面 + 0=0&TEXT(RIGHT(C3,4)&"/"&LEFT(C3,LEN(C3)-5),"E/mm/dd")