偶尔发布的excel办公技巧
-
-
晓得点 一个智能化行业的打杂人员
0 人点赞了该文章 · 789 浏览
=IF(A2=0,"",IF(A2<0,"负","")&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(A2)),"[DBNum2]")&"元"&TEXT(RIGHT(TEXT(A2,".00"),2),"[DBNum2]0角0分"),"零角零分","整"),"零分","整"),"零角","零"),"零元零",""))excel显示大写金额的函数，把A2替换成你要显示的单元格即可
全部 0条评论