EXCEL中金额自动由数字变大写

概要：在存储大写金额的F9单元格中输入公式“=IF(M9<0,"负","")&TEXT(TRUNC(ABS(ROUND(M9,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(M9,2))),"",TEXT(RIGHT(TRUNC(ROUND(M9,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(M9,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(M9,2),3))=".",TEXT(RIGHT(ROUND(M9,2)),"[DBNum2]")&"分","整")”，这样就会自动根据M9中的小写金额自动转

EXCEL中金额自动由数字变大写,标签：办公软件学习,office办公软件教程,http://www.laixuea.com

在存储大写金额的F9单元格中输入公式“

=IF(M9<0,"负","")&TEXT(TRUNC(ABS(ROUND(M9,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(M9,2))),"",TEXT(RIGHT(TRUNC(ROUND(M9,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(M9,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(M9,2),3))=".",TEXT(RIGHT(ROUND(M9,2)),"[DBNum2]")&"分","整")

”，这样就会自动根据M9中的小写金额自动转换为大写金额了。