ABS
假设A1是你输入的数字金额，在旁边加一列如下公式：=SUBSTITUTE(SUBSTITUTE(IF(A10,负,)&TEXT(TRUNC(
ABS(ROUND(A1,2))),[DBNum2])&圆&IF(ISERR(FIND(.,ROUND(A1,2))),,TEXT(RIGHT(TRUNC(ROUND(A1,2)*10)),[DBNum2]))&IF(ISERR(FIND(.0,TEXT(A1,0.00))),角,)&IF(LEFT(RIGHT(ROUND(A1,2),3))=.,TEXT(RIGHT(ROUND(A1,2)),[DBNum2])&分,IF(ROUND(A1,2)=0,,整)),零圆零,),零圆,)1009.12 壹仟零玖圆壹角贰分
