點解會出 -> 港幣/通用格式元

2013-02-27 6:55 pm

copy左下面條formula落excel 但出左-> 港幣/通用格式元

=IF(COUNT(A1),"港幣"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(A1)),"[dbnum2]G/通用格式元")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分;;"&IF(ABS(A1)>1%,"整",)),"零角",IF(ABS(A1)<1,,"零")),"零分","整"),"參","叁"),"")

點解呢?

我用office 2003

請幫忙無言感激!!

回答 (1)

Andy Chan

2013-02-28 3:26 pm

✔ 最佳答案

Please try to change the formula as follows:

=IF(COUNT(A1),"港幣"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(A1)),"[dbnum2]GENERAL元")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分;;"&IF(ABS(A1)>1%,"整",)),"零角",IF(ABS(A1)<1,,"零")),"零分","整"),"參","叁"),"")

i.e. "G/通用格式" --> "GENERAL"

👍 0 👎 0

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

檢視 Wayback Machine 備份