如何在excel 中把A1小写金额转成大写金额填在A2

来源：百度知道 编辑：UC知道 时间：2024/05/13 00:54:26
如何在excel 中把A1小写金额转成大写金额填在A2,并在大写金额位前加上"大写:"

另如何在得数小数金额前加上"小写:" 如A1 =A2+A4"

设A1列为数据列，则在A2输入以下公式(可复制):

=IF(A1<0,"负","")&IF(ABS(A1)>1,TEXT(TRUNC(ABS(ROUND(A1,2))),"[DBNum2]")&"元","")&IF(ISERR(FIND(".",ROUND(A1,2))),"",TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A1,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(A1,2),3))=".",TEXT(RIGHT(ROUND(A1,2)),"[DBNum2]")&"分","整")
在得数小数金额前加上"小写:"的方法:
可以在A1前插入一列输入"小写:" 再选择置右就行.