excel中怎么在单元格大写带元整(取整)

Question

比如在A1输入“12330”，在B1就会跳出壹万贰仟元整（取整）
最主要的是跳出“（取整）”

Answer 1

取整分两步实现

第一是真正取整,相信这是主要的:
B1=round(A1,0)这里是四舍五入到小数点后0位.

第二是显示上取整,设置B1格式:[DBNum2][$-804]G/通用格式 ("取整")
这就是取整后的数字

Answer 2

=IF(ROUND(A1,0)<0,"无效数值",IF(ROUND(A1,0)=0,"零",IF(ROUND(A1,0)<1,"",TEXT(INT(ROUND(A1,0)),"[dbnum2]")&"元")&IF(INT(ROUND(A1,0)*10)-INT(ROUND(A1,0))*10=0,IF(INT(ROUND(A1,0))*(INT(ROUND(A1,0)*100)-INT(ROUND(A1,0)*10)*10)=0,"","零"),TEXT(INT(ROUND(A1,0)*10)-INT(ROUND(A1,0))*10,"[dbnum2]")&"角")&IF((INT(ROUND(A1,0)*100)-INT(ROUND(A1,0)*10)*10)=0,"整",TEXT((INT(ROUND(A1,0)*100)-INT(ROUND(A1,0)*10)*10),"[dbnum2]")&"分")))

Answer 3

数字在A1，在B1输入公式：
=NUMBERSTRING(INT(A1/1000)*1000,2)&"元整(取整)"