数字如何变成中文大写，要求到元小数点后两位

假如A1是数字如1.27,
在B1中输入:
=IF(A1=0,"",IF(INT(A1),TEXT(TRUNC(A1),"[dbnum2]")&"元","")&IF(MOD(A1,1)=0,"整",IF(TRUNC(A1,1),IF(A1=TRUNC(A1,1),TEXT(LEFT(RIGHT(A1*100,2)),"[dbnum2]0角整"),TEXT(RIGHT(A1*100,2),"[dbnum2]0"&IF(LEFT(RIGHT(A1*100,2))="0","","角")&"0分")),TEXT(A1*100,"[dbnum2]0分"))))
则值为"壹元贰角柒分"

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/ee2jv3x72.html