2018年6月21日

转：Excel中数字转大写
摘要： =IF(C13=0,"",IF(C13<0,"负","")&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(C13)),"[DBNum2]")&"元"&TEXT(RIGHT(TEXT(C13,".00"),2),"[DBNum2]0角 阅读全文
posted @ 2018-06-21 16:33 pach 阅读(142) 评论(0) 推荐(0)

导航