Excel中怎样快速地将合计后的小写数字金额转换成大写汉字金额?例如:120 转换成 壹佰贰拾元整 120.5 转换成 壹佰贰拾元伍角整 120.56 转换成 壹佰贰拾元伍角陆分 以前用过公式,但是经常出错,那位高手指点下?
用公式来转换
=IF(A1=0,"",IF(A1<0,"负","")& SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(A1)),"[DBNum2]")&"元"&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(A1*100,2),"[DBNum2]0角0分"),"零分","整"),"零角","零"),"零元零",),"零元",),"零整","整"))