ç¨textå½æ°æå®æ ¼å¼å°±å¯ä»¥äºã
=TEXT(A11,"[dbnum2]")
温馨提示：答案为网友推荐，仅供参考
第1个回答 2017-01-17
假设小写在A1
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ROUND(A1,2)),"[dbnum2]")& "元" & TEXT(ROUND((ROUND(A1,2)-INT(ROUND(A1,2)))*100,0),"[dbnum2]0角0分"),"零角零分","整"),"零分","整"),"零角","零")
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ROUND(A1,2)),"[dbnum2]")& "元" & TEXT(ROUND((ROUND(A1,2)-INT(ROUND(A1,2)))*100,0),"[dbnum2]0角0分"),"零角零分","整"),"零分","整"),"零角","零")
第2个回答 2017-01-17
可以用以下公式：
=TEXT(TRUNC(A1),"[DBNum2]")&"元"&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分整;;"&IF(ABS(A1)>1%,"整",))
=TEXT(TRUNC(A1),"[DBNum2]")&"元"&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分整;;"&IF(ABS(A1)>1%,"整",))
相似回答