excel小写转大写金额|EXCEL小技巧小写金额转为大写金额

【www.bbyears.com--excel】

word-wrap: break-word; margin: 5px 0px; color: rgb(0, 0, 0); font-family: " sans="" font-size:="" font-style:="" font-variant-ligatures:="" a="" href="/fw/photo.html" target="_blank" :="" font-weight:="" letter-spacing:="" orphans:="" text-align:="" text-indent:="" text-transform:="" white-space:="" widows:="" word-spacing:="" -webkit-text-stroke-width:="">打开文件，A列中为需要转换的金额

在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]")&"分")

直接复制就好

回车确认并且填充公式

原文链接：http://jingyan.baidu.com/article/eb9f7b6d60968f869364e8b4.html

本文来源：http://www.bbyears.com/bangongshuma/130822.html