如何让EXCEL2003单元格数值为大写人民币

2024-12-21 21:08:49

推荐回答（4个）

回答1：

　　方法一、在A1单元格输入数字，B1单元格输入“=SUBSTITUTE(SUBSTITUTE(IF(ISNUMBER(FIND(".",A1)),TEXT(LEFT(A1,FIND(".",A1)-1),"[dbnum2]")&"元"&TEXT(MID(A1,FIND(".",A1)+1,1),"[dbnum2]")&"角"&TEXT(MID(A1,FIND(".",A1)+2,1),"[dbnum2]")&"分",TEXT(A1,"[dbnum2]")&"元整"),"角分","角整"),"-","负")”，回车即可。

　　方法二、在A1单元格输入数字，B1单元格输入“=IF(A2<0,"负","")&TEXT(TRUNC(ABS(ROUND(A2,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(A2,2))),"",TEXT(RIGHT(TRUNC(ROUND(A2,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A2,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(A2,2),3))=".",TEXT(RIGHT(ROUND(A2,2)),"[DBNum2]")&"分","整")”，回车

回答2：

A1输入 =round(b1,)
自定义单元格格式为
[DBNum2]G/通用格式"元整"

回答3：

=TEXT(TRUNC(FIXED(ROUND(B1,0))),"[>0][dbnum2];[<0]负[dbnum2];;")&TEXT(RIGHT(FIXED(ROUND(B1,0)),2),"元;;"&IF(ABS(ROUND(B1,0))>1%,"元整",))

回答4：

=SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(B1)),"[>0][dbnum2];[<0]负[dbnum2];;")&TEXT(RIGHT(FIXED(B1),2),"元[dbnum2]0角0分;;"&IF(ABS(B1)>1%,"元整",)),"零角",IF(ABS(B1)<1,,"零")),"零分","整")