excel怎么让用公式计算的金额大写带括号?
发布网友
共1个回答
热心网友
你现在的公式效果是【叁拾元整】这样的效果，你希望修改为【（叁拾元整）】这样吗，那么可以这样做：
="(" & 现在的公式 & ")"
我给你粘贴上去是：
="(" & IF(B8=0,"",IF(B8<0,"负","")&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXT(INT(ABS(B8)),"[DBNum2]")&"元"&TEXT(RIGHT(TEXT(B8,".00"),2),"[DBNum2]0角0分"),"零角零分","整"),"零分","整"),"零角","零"),"零元零","")) & ")"
