excel小写金额改大写公式.xls

文档介绍：,大写::只需更换引用单元格即可。把F8替换成你想要引用的单元格C9=SUBSTITUTE(SUBSTITUTE(IF(F8<0,"负","")&TEXT(TRUNC(ABS(ROUND(F8,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(F8,2))),"",TEXT(RIGHT(TRUNC(ROUND(F8,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(F8,""))),"角","")&IF(LEFT(RIGHT(ROUND(F8,2),3))=".",TEXT(RIGHT(ROUND(F8,2)),"[DBNum2]")&"分",IF(ROUND(F8,2)=0,"","整")),"零元零",""),"零元","零")再示例支付元388792760支付金额大写叁亿捌仟捌佰柒拾玖万贰仟柒佰陆拾元整