先把A1设置成货币格式,然后在B2输入公式:
=IF(AND(A1<=-0.01,A1>=-0.99),"负","")&SUBSTITUTE(SUBSTITUTE(TEXT(TRUNC(A1),"[dbnum2]G/通用格式元;负[dbnum2]G/通用格式元")&TEXT(RIGHT(FIXED(A1),2),"[dbnum2]0角0分;[dbnum2]0角;[dbnum2]整"),"零角","零"),"零分",)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/77c6a7efce1b9d16a89a96b9f3deb48f8d54648c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追问我不需要这种金额式的,只需要我输入的是012 在B2里边显示 零壹贰 就可以了,谢谢