英文版Excel数字金额转换成汉字大写金额

打开EXCEL，在A1单元格中输入小写数字金额

在B2单元格输入下面函数： =IF(ABS(A1)<0.005,"",IF(A1<0,"负",)&IF(INT(ABS(A1)),TEXT(INT(ABS(A1)),"[dbNum2][$-zh-CN]General")&"元",)&IF(INT(ABS(A1)*10)-INT(ABS(A1))*10,TEXT(INT(ABS(A1)*10)-INT(ABS(A1))*10,"[dbNum2][$-zh-CN]General")&"角",IF(INT(ABS(A1))=ABS(A1),,IF(ABS(A1)<0.1,,"零")))&IF(ROUND(ABS(A1)*100-INT(ABS(A1)*10)*10,),TEXT(ROUND(ABS(A1)*100-INT(ABS(A1)*10)*10,),"[dbNum2][$-zh-CN]General")&"分","整")) 可按需要把 A1改成其它单元格

结果如图所示：