数字转中文

=IF(A2=0,"",IF(A2<0,"负","")& SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(A2)),"[DBNum2]")&" 元"&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(A2*100,2),"[DBNum2]0角0分"),"零分"," 整"),"零角","零"),"零元零",),"零元",),"零整","整"))

posted @ 2013-10-30 14:20  与时俱进  阅读(1138)  评论(0编辑  收藏  举报
友情链接:同里老宅院民居客栈