大寫金額 (13207)

C2=IF(INT(B2),TEXT(INT(B2),"[DBNUM2]0元"),"")&IF(MOD(B2,1),TEXT(MID(B2,FIND(".",B2&".")+1,9),"[DBNUM2]"&CHOOSE(LEN(B2)-FIND(".",B2&".")+(ROUND(MOD(B2,1)/1%,)<10)+1,"","0角","0角0分","0分")),"")



留言