Question

Excel中如何把数字转换成中文大写金额？（最简便的方法）

例：
1.11：壹圆壹角一分

Answer 1

恭喜你，我又给你做了个函数的，（已试过）假设1.11在A2格，在b2输入=TEXT(INT(B3),"[DBNUM2]")&"元"&IF(INT(B3)=B3,"整",(IF(INT(B3*10)-INT(B3)*10>0,TEXT(INT(B3*10)-INT(B3)*10,"[DBNUM2]")&"角","零")&IF(B3*100-INT(B3*10)*10>0,TEXT(INT(B3*100-INT(B3*10)*10),"[DBNUM2]")&"分","")))

Answer 2

http://user.qzone.qq.com/59117348/blog/1206972932=IF(A1=0,0,IF(TRUNC(A1)=A1,TEXT(TRUNC(A1),"[dbnum2]G/通用格式"&"元整"),IF(TRUNC(ROUND((A1-INT(A1))*10,2))=ROUND((A1-INT(A1))*10,2),TEXT(TRUNC(A1),"[dbnum2]G/通用格式"&"元")&TEXT(TRUNC(ROUND((A1-INT(A1))*10,2)),"[dbnum2]G/通用格式"&"角整"),TEXT(TRUNC(A1),"[dbnum2]G/通用格式"&"元")&TEXT(TRUNC(ROUND((A1-INT(A1))*10,2)),"[dbnum2]G/通用格式"&"角")&TEXT((ROUND((A1-INT(A1))*10,2)-TRUNC(ROUND((A1-INT(A1))*10,2)))*10,"[dbnum2]G/通用格式"&"分"))))

Answer 3

你若会VBA，请看 http://club.excelhome.net/dispbbs.asp?boardid=3&id=89722