excel中,怎样将325.7元自动变成大写“叁佰贰拾五元柒角整”?答:假设金额在B3单元格,任意单元格输入公式:=IF(B3<0,"负","")&SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(FIXED(ABS(B3))),"[>0][dbnum2];;")&IF(INT(B3),"元",)&TEXT(RIGHT(FIXED(B3),2),"[dbnum2]0角0分;;"&IF(ABS(B3)>1%,"元整",)),"零角",IF(ABS(B3)<1,,"零")),"零分"...