1个公式搞定阿拉伯数字转换为会计专用的中文大写，财务会计考试要看的Excel函数公式
非会计专用格式
要将数字转换为中文形式，只要你认识下面这个函数就很容易。
要转换为中文小写数字：=NUMBERSTRING(A2,1)
要转换为中文大写数字：=NUMBERSTRING(A2,2)
要转换为逐个小写数字：=NUMBERSTRING(A2,3)
会计专用格式下的转换方法
阿拉伯数字转会计专用中文大写，也是一个公式即可搞定!
=IF(ROUND(A2,2)<0,"无效数字",IF(ROUND(A2,2)=0,"零",IF(ROUND(A2,2)<1,"",TEXT(INT(ROUND(A2,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A2,2)*10)-INT(ROUND(A2,2))*10=0,IF(INT(ROUND(A2,2))*(INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(A2,2)*10)-INT(ROUND(A2,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10)=0,"整",TEXT((INT(ROUND(A2,2)*100)-INT(ROUND(A2,2)*10)*10),"[dbnum2]")&"分")))
方法2：
=IF(A2>0,IF(A2>=1,IF(AND(A2>10^4,INT((A2/10^5-INT(A2/10^5))*10)=0,INT((A2%%-INT(A2%%))*10)>0),SUBSTITUTE(NUMBERSTRING(INT(A2),2),"万","万零"),NUMBERSTRING(INT(A2),2))&"元",)&IF(AND(A2>1,INT((A2/10-INT(A2/10))*10)=0,INT((A2-INT(A2))*10)>0),"零",)&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(A2),2),"[dbnum2]0角0分;;整"),"零角",IF(A2<1,,"零")),"零分","整"),"零元整")
方法3：
=SUBSTITUTE(SUBSTITUTE(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]")&"分",IF(ROUND(A2,2)=0,"","整")),"零元零",""),"零元","")
方法4：
=SUBSTITUTE(SUBSTITUTE(IF(-RMB(A2),IF(A2>0,,"负")&TEXT(INT(ABS(A2)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(RMB(A2,2),2),"[dbnum2]0角0分;;整"),),"零角",IF(A2^2<1,,"零")),"零分","整")
推荐阅读：
延伸阅读：
更多初级会计师考试报考条件、考试时间和历年真题在这里>>>初级会计师考试
想考试拿高分? 考无忧助你考试无忧>>>专家推荐在线考题 >>>考无忧2018年初级会计师考试辅导题库软件(含历年真题)
