我要用於開支票
=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變成參,請問如何改成叁??
EXCEL 參改成叁
2012-02-10 9:29 pm
回答 (1)
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)&"分")&"正","參","叁")
收錄日期: 2021-04-24 10:46:26
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20120210000051KK00265