中文數字 轉換成小寫數字 (12337)

C2=IFERROR(SUBSTITUTE(B2,LOOKUP(1,0/FIND(TEXT(ROW($1:$999),"[DBNUM1]")&"號",B2),TEXT(ROW($1:$999),"[DBNUM1]")&"號"),LOOKUP(1,0/FIND(TEXT(ROW($1:$999),"[DBNUM1]")&"號",B2),ROW($1:$999))&"號"),B2)

大寫數字改小寫數字--> [DBNUM1] 1改 3   號改鄰



留言