=SUBSTITUTE(SUBSTITUTE(IF(I138<0,"负","")&TEXT(TRUNC(ABS(ROUND(I138,2))),"[DBNum2]")&"元"&IF(ISERR(FIND(".",ROUND(I138,2))),"",TEXT(RIGHT(TRUNC(ROUND(I138,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(I138,"0.00"))),"角","")&IF(LEFT(RIGHT(ROUND(I138,2),3))=".",TEXT(RIGHT(ROUND(I138,2)),"[DBNum2]")&"分",IF(ROUND(I138,2)=0,"","整")),"零元零",""),"零元","零")

就是这个格子自带的公式，比如说15.2   我想要的事壹拾伍元贰角，但是会显示壹拾伍元贰角整