大小寫數(shù)字轉(zhuǎn)換，數(shù)字大小寫轉(zhuǎn)換問題C

來源：整理時間：2023-03-04 20:47:04 編輯：好學習手機版

本文目錄一覽

1，數(shù)字大小寫轉(zhuǎn)換問題C
2，excel數(shù)字大小寫轉(zhuǎn)換

1，數(shù)字大小寫轉(zhuǎn)換問題C

這個比較簡單用一個一維數(shù)組記錄中文單位，例如十百千再用一個一維數(shù)組記錄中文數(shù)字，例如：壹，………… 然后就利用數(shù)字的（除去小數(shù)點及以后的）位數(shù)和具體數(shù)字進行拼接

數(shù)字大小寫轉(zhuǎn)換問題C

2，excel數(shù)字大小寫轉(zhuǎn)換

大寫的話如果是角后面不是要帶整字嗎?好像分才不用。你先確定一下，如果角要帶整的話公式里有兩個地方有“角”，改第一個就可以，以下默認單元格A1為數(shù)字金額欄，具休位置有變把A1改一下就好：=IF(INT(A1)*100=A1*100,"人民幣"&TEXT(INT(A1),"[DBNum2]")&"元整",IF(INT(A1*10)=A1*10,"人民幣"&TEXT(INT(A1),"[DBNum2]")&"元"&TEXT(A1*10-INT(A1)*10,"[DBNum2]")&"角","人民幣"&TEXT(INT(A1),"[DBNum2]")&"元"&IF(INT(A1*10)=INT(A1)*10,"零",TEXT(RIGHT(INT(A1*10)),"[DBNum2]")&"角")&TEXT(RIGHT(A1*100),"[DBNum2]")&"分"))

="人民幣"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(G5),"[dbnum2]G/通用格式元"&IF(MOD(G5,1),"","整")&";;;")&TEXT(--RIGHT(INT(G5*10)),"[dbnum2][>0]#角;[=0]")&TEXT(--RIGHT(INT(G5*100)),"[dbnum2][>0]#分;[=0]整"),"元0","元零"),0,),"整整","整")

參考：Excel函數(shù)公式：人民幣大寫轉(zhuǎn)換http://www.pootor.com/excel-formula-transfer-rmb-numbers-to-words/

=IF(G213<0,"無效數(shù)值",IF(G213=0,"",IF(G213<1,"",TEXT(INT(G213),"[dbnum2]")&"元")&IF(INT(G213*10)-INT(G213)*10=0,IF(INT(G213)*(INT(G213*100)-INT(G213*10)*10)=0,"","零"),IF(AND((INT(G213)-INT(G213/10)*10)=0,INT(G213)>0),"零"&TEXT(INT(G213*10)-INT(G213)*10,"[dbnum2]")&"角",TEXT(INT(G213*10)-INT(G213)*10,"[dbnum2]")&"角"))&IF((INT(G213*100)-INT(G213*10)*10)=0,"整",TEXT(INT(G213*100)-INT(G213*10)*10,"[dbnum2]")&"分")))你的數(shù)據(jù)在G213！

很奇怪的需求。假如62.40在A1，公式為=TEXT(A1*100,"0 0 0萬0仟0佰0拾0元0角0分[DBNum2]")

excel數(shù)字大小寫轉(zhuǎn)換