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

时间:2024-11-04 15:46:40

1、打开excel2010

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

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,,"零")),"零分","整")

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

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

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

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

Excel怎么把小写金额转大写金额
© 手抄报圈