社区首页 › EXCEL、WORD财务应用 › Excel实现大小写金额转换的代码

银河飞雪 发表于 2007-9-10 12:47:39

Excel实现大小写金额转换的代码

‘=IF(ISNUMBER($N$49),IF($N$49<0,"无效数值",IF($N$49<0.005,"零",IF($N$49<0.995,"",TEXT(INT($N$49+0.005),"")&"元")&IF(LEFT(RIGHT(FIXED($N$49,2),2),1)="0",IF(RIGHT(FIXED($N$49,2),1)="0","",IF($N$49>0.995,"零","")),TEXT(LEFT(RIGHT(FIXED($N$49,2),2),1),"")&"角")&IF(RIGHT(FIXED($N$49,2),1)="0","整",TEXT(RIGHT(FIXED($N$49,2),1),"")&"分"))),"非数值!")

大小写在财务工作中经常要用到,希望能给大家带来帮助

威海本溪人 发表于 2009-7-10 15:02:22

唉，看不明白:Q :Q

查看完整版本: Excel实现大小写金额转换的代码