大写金额 (10347)

D2=IF(B2>=1,TEXT(INT(B2),"[DBNUM2]")&"元","")&SUBSTITUTE(SUBSTITUTE(TEXT(MOD(B2*100,100),"[DBNUM2]0角0分;;"),"零角",),"零分",)

考慮負值=IF(B2<>"",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(B2<0,"负","")&TEXT(INT(ABS(B2)),"[dbnum2];; ")&TEXT(MOD(ABS(B2)*100,100),"[>9][dbnum2]元0角0分;[=0]元;[dbnum2]元零0分"),"零分","")," 元零",)," 元",),"")