在excel和word中小写金额数字变成大写的金钱表达?
发布网友
共2个回答
热心网友
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ROUND(a1,2)),"[dbnum2]")&"元"&TEXT(RIGHT(ROUND(a1,2)*100,2),"[dbnum2]0角0分"),"零角零分","整"),"零角","零"),"零分","整")
热心网友
=SUBSTITUTE(SUBSTITUTE(IF(A1>-0.5%,,"负")&TEXT(INT(FIXED(ABS(A1))),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分整;;"&IF(ABS(A1)>1%,"整",)),"零角整",IF(ABS(A1)<1,,"零")),"零分整","整")
