作者：乔山办公网日期：
返回目录：excel表格制作
=SUBSTITUTE(SUBSTITUTE(IF(A1>-0.5%,,"负")&TEXT(INT(FIXED(ABS(A1))),"[dbnum2]G/通用格百式元度;;")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角回0分答;;"&IF(ABS(A1)>1%,"整",)),"零角",IF(ABS(A1)<1,,"零")),"零分","整")
方法：百
1、打开EXCEL表格，A1输入小写度金额，在问C1列输入：=SUBSTITUTE(SUBSTITUTE(IF(A1>-0.5%,,"负")&TEXT(INT(FIXED(ABS(A1))),"[dbnum2]G/通用格式元答;;")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角内0分;;"&IF(ABS(A1)>1%,"整",)),"零角",IF(ABS(A1)<1,,"零")),"零分","整")
2、确定容后效果如图。
不需要宏吧，用函数就可以实百现，请问，金额最大能到多少？这对编写函度数有用！
我已经帮你用函数实现了，费了我不少脑细胞，你试试看看是否满意。比如你的A1格输入1000000.01，要在B1格把它转换版为中文大写，你只需要在B1复制以下函数：
=TEXT(TRUNC(A1),"[Dbnum2]")&"圆权"&IF(ROUND((A1-TRUNC(A1))*100,1)<>0,IF(LEN(ROUND((A1-TRUNC(A1))*100,1))=1,"零角"&TEXT(ROUND((A1-TRUNC(A1))*100,1),"[Dbnum2]")&"分",TEXT((ROUND((A1-TRUNC(A1))*100,1)-MOD(ROUND((A1-TRUNC(A1))*100,1),10))/10,"[Dbnum2]")&"角"&TEXT(MOD(ROUND((A1-TRUNC(A1))*100,1),10),"[Dbnum2]")&"分"),"零角零分 ")
下面这个公式知可以实现：道
=IF(ROUND(A1,2)<0,"无效数值回",IF(ROUND(A1,2)=0,"零",IF(ROUND(A1,2)<1,"",TEXT(INT(ROUND(A1,2)),"[dbnum2]")&"元")&IF(INT(ROUND(A1,2)*10)-INT(ROUND(A1,2))*10=0,IF(INT(ROUND(A1,2))*(INT(ROUND(A1,2)*100)-INT(ROUND(A1,2)*10)*10)=0,"","零角"),TEXT(INT(ROUND(A1,2)*10)-INT(ROUND(A1,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(A1,2)*100)-INT(ROUND(A1,2)*10)*10)=0,"整",TEXT((INT(ROUND(A1,2)*100)-INT(ROUND(A1,2)*10)*10),"[dbnum2]")&"分答")))