Excel一个公式搞定金额大写

方式二公式：=TEXT(A1,"[DBNum2]")。
方式三显示元角分整零的公式：=IF(ROUND(B5,2)=0,"",IF(ROUND(B5,2)<0,"负","")&TEXT(INT(ABS(ROUND(B5,2))),"[DBNum2]")&"元"&IF(INT(ABS(ROUND(B5,2))*10)-INT(ABS(ROUND(B5,2)))*10=0,IF(INT(ABS(ROUND(B5,2))*100)-INT(ABS(ROUND(B5,2))*10)*10=0,"整","零"),TEXT(INT(ABS(ROUND(B5,2))*10)-INT(ABS(ROUND(B5,2)))*10,"[DBNum2]")&"角")&IF(INT(ABS(ROUND(B5,2))*100)-INT(ABS(ROUND(B5,2))*10)*10=0,"",TEXT(INT(ABS(ROUND(B5,2))*100)-INT(ABS(ROUND(B5,2))*10)*10,"[DBNum2]")&"分"))
ROUND(A1,2)：自动四舍五入保留 2 位小数，规避多位小数造成的分位错乱。如果不需要四舍五入，可删除公式里所有ROUND(B5,2)，直接写 B5。