如何将一个单元格中小写金额在另外一个单元格中显示大写金额

2024-11-22 03:04:46

推荐回答（2个）

回答1：

比如D47单元格为小写金额，公式为：
=IF(D47<0,"负","")&TEXT(TRUNC(ABS(ROUND(D47,2))),"[DBNum2]")&"圆"&IF(ISERR(FIND(".",ROUND(D47,2))),"",TEXT(RIGHT(TRUNC(ROUND(D47,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(D47,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(D47,2),3))=".",TEXT(RIGHT(ROUND(D47,2)),"[DBNum2]")&"分","整")

回答2：

如A1为小写金额，B1为大写金额则
B1=TEXT(A1*100,"[dbnum2]0拾0万0仟0佰0拾0元0角0分")