excel数值以万/千为单位显示，数值转大写，转财务大写

在不改变数值（如图中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分")),"-",""),"零角零分","整"),"零分","整"),"零角","零")