Warrior Sun

内蒙古强网电子科技有限公司

导航

在Excel中将数字转换为大写

Posted on 2015-07-20 07:35  Warrior Sun  阅读(422)  评论(0编辑  收藏  举报

123.09 = 壹佰贰拾叁元零玖分

=SUBSTITUTE(SUBSTITUTE(IF(G10<0,"負","")&TEXT(TRUNC(ABS(ROUND(G10,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(G10,2))),"",TEXT(RIGHT(TRUNC(ROUND(G10,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(G10,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(G10,2),3))=".",TEXT(RIGHT(ROUND(G10,2)),"[DBNum2]")&"分",IF(ROUND(G10,2)=0,"","整")),"零元零",""),"零元","")



把G10改成你要的单元格