关于请求支票模板数字转换大写的问题

lizhengquan

我打印的支票拿到银行提款，建行说截止到元可以用整（例如：123    壹佰贰拾叁元整），截止到分不要整（例如：123.4  壹佰贰拾叁元肆角）下面的公式真么改呀！谢谢各位。
=IF(A4=0,"",IF(ROUND(D25,2)<0,"无效数字",IF(ROUND(D25,2)=0,"零",IF(ROUND(D25,2)<1,"",TEXT(INT(ROUND(D25,2)),"[dbnum2]")&"元")&IF(INT(ROUND(D25,2)*10)-INT(ROUND(D25,2))*10=0,IF(INT(ROUND(D25,2))*(INT(ROUND(D25,2)*100)-INT(ROUND(D25,2)*10)*10)=0,"","零"),TEXT(INT(ROUND(D25,2)*10)-INT(ROUND(D25,2))*10,"[dbnum2]")&"角")&IF((INT(ROUND(D25,2)*100)-INT(ROUND(D25,2)*10)*10)=0,"整",TEXT((INT(ROUND(D25,2)*100)-INT(ROUND(D25,2)*10)*10),"[dbnum2]")&"分"))))

LangQueS

建议楼主上传问题附件，或在论坛搜索“大写”相关主题。