C2=LOOKUP(1,0/FIND(SUBSTITUTE(TEXT(ROW($1900:$3000),"[DBNUM1]0"),"○","零"),A2),ROW($1900:$3000))&"年"&LOOKUP(1,0/FIND(SUBSTITUTE(TEXT(ROW($1:$12),"[DBNUM1]"),"一十","十")&"月",A2),ROW($1:$12))&"月"&LOOKUP(1,0/FIND(SUBSTITUTE(TEXT(ROW($1:$31),"[DBNUM1]"),"一十","十")&"日",A2),ROW($1:$31))&"日"
留言
張貼留言