EXCEL2010 人民币大小写金额转换 公式后仍无法转化,¥828元公式后变成...答:假设金额在G2单元,大写在D2内。D2=CONCATENATE("人民币",IF(G2=0,"",IF(ABS(G2)<0.995,"",TEXT(INT(ROUND(ABS(G2),2)),"[DBNum2]")&"元")&IF(RIGHT(TEXT(G2,".00"),2)*1=0,IF(ABS(G2)<0.005,"","整"),TEXT(IF(ABS(G2)<0.095,...
EXCEL怎么自动转换有小数点的小数点金额大小写,有没有简单的方法啊,谢...答:0万0仟0佰0仕0元0角0分")或者 =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ROUND(A3,2)),"[dbnum2]")& "元" & TEXT(ROUND((ROUND(A3,2)-INT(ROUND(A3,2)))*100,0),"[dbnum2]0角0分"),"零角零分","整"),"零角","零"),"零分","整")上面那个公式只能用来粗略转换,...