最完美的函数公式，强烈推荐大家使用
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(-RMB(C2,2),TEXT(C2,";负")&TEXT(INT(ABS(C2)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(RMB(C2,2),2),"[dbnum2]0角0分;;整"),),"零角",IF(C2^2<1,,"零")),"万",IF(AND(MOD(ABS(C2%),1000)<100,MOD(ABS(C2%),1000)>=10),"万零","万")),"零分","整")
显示金额：壹万壹仟肆佰叁拾伍元整
壹万壹仟陆佰伍拾贰元伍角整
壹万壹仟陆佰叁拾叁元贰角叁分
