同学，你好 可以用=IF(ROUND(小写金额单元格,2)=0,"零圆整",IF(小写金额单元格＜0,"负","")&IF(ABS(小写金额单元格)>=1,TEXT(INT(ROUND(ABS(小写金额单元格),2)),"[dbnum2]")&"圆","")&SUBSTITUTE(SUBSTITUTE(TEXT(RIGHT(RMB(小写金额单元格,2),2),"[dbnum2]0角0分;;整"),"零角",IF(小写金额单元格^2<1,,"零")),"零分","整"))。 其中小写金额单元格即你需要转化的数字所在位置