EXCEL中数字自动变成大写金额的4种方法

小萌包

好象是作者在角和分之间漏写了一个判断，我改成如下这样就不会在角分之间多一个0了，=IF(B2=0,"零元",IF(B2<0,"负","")&TEXT(INT(ABS(B2)),"[DBNum2][$-804]General")&"元"&IF(INT(ABS(B2)*10)-INT(ABS(B2))*10=0,"",TEXT(INT(ABS(B2)*10)-INT(ABS(B2))*10,"[DBNum2][$-804]General")&"角")&IF((INT(ABS(B2)*100)-INT(ABS(B2)*10)*10)=0,"整",IF(INT(ABS(B2)*10)-INT(ABS(B2))*10=0,"零"&TEXT(INT(ABS(B2)*100)-INT(ABS(B2)*10)*10,"[DBNum2][$-804]General")&"分",TEXT(INT(ABS(B2)*100)-INT(ABS(B2)*10)*10,"[DBNum2][$-804]General")&"分")))