Excel怎么把小写金额转大写金额

1、打开excel2010

2、在C3中输入   =SUBSTITUTE(SUBSTITUTE(IF(B3>-0.5%,,"负")&TEXT(INT(ABS(B3)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(B3),2),"[dbnum2]0角0分;;"&IF(ABS(B3)>1%,"整",)),"零角",IF(ABS(B3)<1,,"零")),"零分","整")    

3、输入完后按回车键，这样小写金额就变成大写金额了

4、最后，只需要将单元格向下填充到自己需要的单元格这样小写金额就变成大写金额了