请教EXCEL金额大小写转换问题 必须显示零角零分答:额,下面是我用的,好像不行。=IF(ISNUMBER(U18),SUBSTITUTE(SUBSTITUTE(IF(U18=TRUNC(U18),NUMBERSTRING(U18,2)&"元整",IF(U18*10=TRUNC(U18*10),NUMBERSTRING(TRUNC(U18),2)&"元"&NUMBERSTRING(MID(U18,FIND(".",U18)+1,1),2)&"角整",NUMBERSTRING(TRUNC(U18),2)&"元"&NUMBERSTRING(...
Excel中金额转换大小写出错,无法显示大写只显示数字,求解决办法!_百度...答:=IF(A2<0,"负","")&TEXT(INT(ABS(A2)),"[DBNUM2]")&"元"&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(A2*100,2),"[DBNUM2]0角0分"),"零角零分","整"),"零分","整")