在不改变数值(如图中B5)的情况下,改变数值的显示样,操作方法如下:
图中单元格B10公式为:
=IF(B1<0,"负","")&TEXT(INT(ABS(B1)),"[DBNUM2]")&"元"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(B1<0,TEXT(MOD(B1,-1)*100,"[DBNUM2]0角0分"),TEXT(MOD(B1,1)*100,"[DBNUM2]0角0分")),"-",""),"零角零分","整"),"零分","整"),"零角","零")