...的小写数字金额转换成大写汉字金额?例如:120 .25元转换成 壹佰...答:=SUBSTITUTE(SUBSTITUTE(IF(-RMB(A1),IF(A1>0,,"负")&TEXT(INT(ABS(A1)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(RMB(A1,2),2),"[dbnum2]0角0分;;整"),),"零角",IF(A1^2<1,,"零")),"零分","整")
excel统计中怎样把小写转化为大写四舍五入到元 如:123.78写成壹佰...答:假设数字在A1 =SUBSTITUTE(SUBSTITUTE(IF(ROUND(A1,)>-0.5%,,"负")&TEXT(INT(ABS(ROUND(A1,))+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(ROUND(A1,)),2),"[dbnum2]0角0分;;"&IF(ABS(ROUND(A1,))>1%,"整",)),"零角",IF(ABS(...