Excel 想在格中显示人民币大写圆整，公式是什么？

这是前面没有美元符号的公式看你的能不能去掉美元符号=SUBSTITUTE(SUBSTITUTE(IF(C8<0,"负","")&TEXT(TRUNC(ABS(ROUND(C8,2))),"[DBNum2]")&"元 "&IF(ISERR(FIND(".",ROUND(C8,2))),"",TEXT(RIGHT(TRUNC(ROUND(C8,2)*10)),"[DBNum2]"))&IF(ISERR(FIND(".0",TEXT(C8,"0.00"))),"角 ","")&IF(LEFT(RIGHT(ROUND(C8,2),3))=".",TEXT(RIGHT(ROUND(C8,2)),"[DBNum2]")&"分",IF(ROUND(C8,2)=0,"","整")),"零元零",""),"零元","")