0][dbnum2];[分;;"&IF(ABS(A1)>1%,"元整",)),"零角",IF(ABS(A1)" />
搜档网

搜档网

当前位置:搜档网 > 函数公式-小写转大写

函数公式-小写转大写

20140920小写转大写:(有用)

=SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(A1)),"[>0][dbnum2];[<0]负 [dbnum2];;")&TEXT(RIGHT(FIXED(A1),2),"元 [dbnum2]0角 0

分 ;;"&IF(ABS(A1)>1%,"元整 ",))," 零角 ",IF(ABS(A1)<1,,"零 "))," 零分 "," 整 ")

TOP相关主题