Excel 數字變中文大寫及英文大寫(開支票用)

[匿名]

2011-02-18 6:32 am

請問EXCEL有沒有FUNCTION KEY可以將數字變成中文大寫及英文大寫(開支票用)呢？煩請幫忙，謝謝！

回答 (1)

Andy Chan

2011-02-19 3:41 pm

✔ 最佳答案

請參考:

http://hk.knowledge.yahoo.com/question/question?qid=7010092800142

http://hk.knowledge.yahoo.com/question/question?qid=7010032200745

2011-02-20 08:26:36 補充：
try this:

="港幣"&TEXT(INT(A1),"[dbnum2]")&"元"&TEXT(INT((A1-INT(A1))*10),"[dbnum2]")&"角"&TEXT(INT((A1*10-INT(A1*10))*10),"[dbnum2]")&"分"

2012-02-11 18:08:09 補充：
公式應修改如下:

="港幣"&NUMBERSTRING(INT(B7),2)&"元"&IF(MOD(INT(B7*10),10)=0,"",NUMBERSTRING(MOD(INT(B7*10),10),2)&"角")&IF(MOD(INT(B7*100),10)=0,"",NUMBERSTRING(MOD(INT(B7*100),10),2)&"分")&"正"

👍 1 👎 0