四种EXCEL小写数字转财务金额大写，全部会的人不多

4种数字转财务金额大写摆技巧，函数公式：=SUBSTITUTE(SUBSTITUTE(TEXT(INT(A3),"[DBNum2][$-804]G/通用格式元"&IF(INT(A3)=A3,"整",""))&TEXT(MID(A3,FIND(".",A3&".0")+1,1),"[DBNum2][$-804]G/通用格式角")&TEXT(MID(A3,FIND(".",A3&".0")+2,1),"[DBNum2][$-804]G/通用格式分"),"零角","零"),"零分","")