[EXCEL技巧]将小写金额转为大写金额
1、打开文件，A列中为需要转换的金额
![[EXCEL技巧]将小写金额转为大写金额](https://exp-picture.cdn.bcebos.com/a151a233ec3834bb866b18ea8714c27bd3823dde.jpg)
2、在b2单元格中输入公式=IF(INT(A2)=A2,TEXT(A2,"[蟠校盯昂dbnum2]"稆糨孝汶;)&"元整",TEXT(INT(A2),"[dbnum2]")&"元"&TEXT(LEFT(RIGHT(A2*100,2),1),"[dbnum2]")&"角"&TEXT(RIGHT(A2*100,1),"[dbnum2]")&"分")直接复制就好
![[EXCEL技巧]将小写金额转为大写金额](https://exp-picture.cdn.bcebos.com/bd72f23834bb19ef02dbb6a1497bd28287893ade.jpg)
3、回车确认并且填充公式
![[EXCEL技巧]将小写金额转为大写金额](https://exp-picture.cdn.bcebos.com/ed792abb19efa25fad9078ce59828689a0463bde.jpg)
1、打开文件，A列中为需要转换的金额
2、在b2单元格中输入公式=IF(INT(A2)=A2,TEXT(A2,"[蟠校盯昂dbnum2]"稆糨孝汶;)&"元整",TEXT(INT(A2),"[dbnum2]")&"元"&TEXT(LEFT(RIGHT(A2*100,2),1),"[dbnum2]")&"角"&TEXT(RIGHT(A2*100,1),"[dbnum2]")&"分")直接复制就好
3、回车确认并且填充公式