数字转中文

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

【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/top5/p/3396621.html