=SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负")&TEXT(INT(FIXED(ABS(A2))),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]0角0分整;;"&IF(ABS(A2)>1%,"整",)),"零角整",IF(ABS(A2)<1,,"零")),"零分整","整")其中A2为转换数字的标号
excel技巧总结(不断添加中........)
最新推荐文章于 2020-12-03 13:36:55 发布