Question

EXCEL中怎样运用函数将数值转换成金额大写形式

Answer 1

例如在B1单元格输入如下公式，可转换A1单元格的数字；（式中的A1可改为单元格应用）。
=IF((A1-INT(A1))=0,TEXT(A1,"[DBNUM2]")&"元整",IF(INT(A1*10)-A1*10=0,TEXT(INT(A1),"[DBNUM2]")&"元"&TEXT((INT(A1*10)-INT(A1)*10),"[DBNUM2]")&"角整",TEXT(INT(A1),"[DBNUM2]")&"元"&IF(INT(A1*10)-INT(A1)*10=0,"零",TEXT(INT(A1*10)-INT(A1)*10,"[DBNUM2]")&"角")&TEXT(RIGHT(A1,1),"[DBNUM2]")&"分"))

Answer 2

=TEXT(SUM($E$5:$E$9)*100,"[dbnum2]0 拾 0 万 0 仟 0 佰 0 拾 0 元 0 角 0 分")
$E$5:$E$9为要改写的单元格