0][dbnum2];[[dbnum2];;")&TEXT(RIGHT(FIXED(A1),2),"元[dbnum2]0角0分;;"&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相关主题