excel小写变大写函数答:excel小写变大写函数 我们在B2中输入公式:=SUBSTITUTE(SUBSTITUTE(TEXT(INT(A2),"[DBNum2][$-804]G/通用格式元"&IF(INT(A2)=A2,"整",""))&TEXT(MID(A2,FIND(".",A2&".0")+1,1),"[DBNum2][$-804]G/通用格式角")&TEXT(MID(A2,FIND(".",A2&".0")+2,1),"[DBNum2][$-...
在EXCEL中如何将小写金额用函数转换成大写金额,谢谢答:1、=SUBSTITUTE(SUBSTITUTE(IF(A11<0,"负","")&TEXT(TRUNC(ABS(ROUND(A11,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(A11,2))),"",TEXT(RIGHT(TRUNC(ROUND(A11,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(A11,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(...