求一特别的EXCEL金额小写变大写的公式

来源：百度知道 编辑：UC知道 时间：2024/06/08 10:43:20
具体要求如下！！如金额为123456789，应该显示：壹亿贰仟叁佰肆拾伍万陆仟柒佰捌拾玖元整
但我要做到如果：当金额只有123456时显示： 亿 仟 佰 壹拾贰万叁仟肆佰伍拾陆元整
既就算无数字都有实际单位的存在！！

你好!
设 A1为数据单元格
参考如下，可以支持到“千万”，

=TEXT(MID(INT(A1),1,1),"[dbnum2]")&CHOOSE(LEN(INT(A1)),"圆","拾"," 佰","仟","万","拾万","百万","千万")&IF(LEN(INT(A1))-1<=0,"",TEXT(MID(INT (A1),2,1),"[dbnum2]")&CHOOSE(LEN(INT(A1))-1,"圆","拾","佰","仟","万","拾万 ","百万","千万"))&IF(LEN(INT(A1))-2<=0,"",TEXT(MID(INT(A1),3,1)," [dbnum2]")&CHOOSE(LEN(INT(A1))-2,"圆","拾","佰","仟","万","拾万","百万","千万 "))&IF(LEN(INT(A1))-3<=0,"",TEXT(MID(INT(A1),4,1),"[dbnum2]")& CHOOSE(LEN(INT(A1))-3,"圆","拾","佰","仟","万","拾万","百万","千万"))&IF(LEN (INT(A1))-4<=0,"",TEXT(MID(INT(A1),5,1),"[dbnum2]")&CHOOSE(LEN(INT (