EXCEL中怎么自动把阿拉伯数字转换成汉字大写？？ 比如 我上面一格写的三百元，下面就显示叁佰元？？？

---

="大写："&SUBSTITUTE(SUBSTITUTE(IF(ROUND(A2,2),TEXT(A2,";负"山御配逗指)&TEXT(INT(ABS(A2)+0.5%),"[dbnum2]G/拆州通用格式元;;")&TEXT(RIGHT(TEXT(,FDeQSQ

---

=IF(A1<0,"负","")&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]")&"分","整握搜")

---

下载个转换插件

---