EXCEL 參改成叁

2012-02-10 9:29 pm

我要用於開支票
=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)&"分")&"正"

但B7內的3變成參,請問如何改成叁??

回答 (1)

Andy Chan

2012-02-11 6:20 am

✔ 最佳答案

try this:

=SUBSTITUTE(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

收錄日期: 2021-04-24 10:46:26
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20120210000051KK00265

檢視 Wayback Machine 備份