|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
大写金额感觉不太美观,可以改成这个函数=IF(E12=0,"",IF(AND(ISERR(FIND("拾万零",TEXT(INT(E12),"[dbnum2]"))),ISERR(FIND("拾万元",TEXT(INT(E12),"[dbnum2]")&"元"))),SUBSTITUTE(TEXT(INT(E12),"[DBNum2]"),"拾万","拾万零")&"元",TEXT(INT(E12),"[dbnum2]")&"元"))&IF(INT(E12*10)-INT(E12)*10=0,IF(INT(E12)*(INT(E12*100)-INT(E12*10)*10)=0,"","零"),IF(AND((INT(E12)-INT(E12/10)*10)=0,INT(E12)>0),"零"&TEXT(INT(E12*10)-INT(E12)*10,"[dbnum2]")&"角",TEXT(INT(E12*10)-INT(E12)*10,"[dbnum2]")&"角"))&IF((INT(E12*100)-INT(E12*10)*10)=0,"整",TEXT(INT(E12*100)-INT(E12*10)*10,"[dbnum2]")&"分") |
|