EXCEL中小写转换大写的公式,从哪里开始理解呢?谢谢!
=SUBSTITUTE(SUBSTITUTE(IF(H11<0,"负","")&TEXT(TRUNC(ABS(ROUND(H11,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(H11,2))),"",TEXT(RIGHT(TRUNC(ROUND(H11,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(H11,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(H11,2),3))=".",TEXT(RIGHT(ROUND(H11,2)),"[DBNum2]")&"分",IF(ROUND(H11,2)=0,"","整")),"零元零",""),"零元","")
同求一样的问题,谁能把SUBSTITUTE详细完整解释一下
答:一般都是其它程序导出来的. 全部的字符都有对应的数字代码.详情>>