Discussion:
數字轉換成 新台幣大寫文字 增益集找不到 tdollar
(时间太久无法回复)
rongin
2007-05-16 13:53:02 UTC
Permalink
30 顯示新台幣参拾元,如何做?
JUDY
2007-05-17 02:00:01 UTC
Permalink
儲存格格式-->自訂--> [DBNum2]"新台幣"[$-404]G/通用格式"元整"
就可以了
ªá¥Ò¯Î
2007-05-17 11:40:22 UTC
Permalink
IF(C18="","",IF(INT(C18)-C18=0,TEXT(INT(C18),"[dbnum2]")&"¶ê¥¿",IF(INT(C18*100)-INT(C18*10)*10=0,TEXT(INT(C18),"[dbnum2]")&"¶ê"&TEXT(MID(C18,SEARCHB(".",C18,1)+1,1),"[dbnum2]")&"š€¥¿",IF(INT(C18*10)-INT(C18)*10=0,TEXT(INT(C18),"[dbnum2]")&"¶ê"&"¹s"&TEXT(MID(C18,SEARCHB(".",C18,1)+2,1),"[dbnum2]")&"€À¥¿",TEXT(INT(C18),"[dbnum2]")&"¶ê"&TEXT(MID(C18,SEARCHB(".",C18,1)+1,1),"[dbnum2]")&"š€"&TEXT(MID(C18,SEARCHB(".",C18,1)+2,1),"[dbnum2]")&"€À¥¿"))))
30 Åã¥Ü·s¥x¹ô?¬B€ž¡AŠpŠó°µ¡H
Loading...