金额亿千百十万千百十元角分-258.27 ￥-25827251.05 ￥25105125,987.99 ￥12598799268.07 ￥26807-1.00 ￥-1000.83 ￥830.90 ￥90181=SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负")&TEXT(INT(ABS(A2)+0.5%),183=SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负")&TEXT(INT(FIXED(ABS(A2))194=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负")&TEXT(INT(FIX196=SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负")&IF(ABS(A2)+0.5%<1,,TEXT200=SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负")&IF(INT(ABS(A2)+0.5%)<1,294=SUBSTITUTE(SUBSTITUTE(IF(A2>-0.5%,,"负")&IF(INT(ABS(A2)+0.5%),NUSUBSTITUTE、TEXT函数及[dbnum2]格式1SUBSTITUTE、TEXT函数及[dbnum2]格式2负贰佰伍拾捌元贰角柒分负贰佰伍拾捌元贰角柒分贰佰伍拾壹元零伍分贰佰伍拾壹元零伍分壹拾贰万伍仟玖佰捌拾柒元玖角壹拾贰万伍仟玖佰捌拾柒元玖角玖分贰佰陆拾捌元零柒分贰佰陆拾捌元零柒分负壹元整负壹元整捌角叁分捌角叁分玖角整玖角整181183-0.5%,,"负")&TEXT(INT(ABS(A2)+0.5%),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]0角-0.5%,,"负")&TEXT(INT(FIXED(ABS(A2))),"[dbnum2]G/通用格式元;;")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]TUTE(IF(A2>-0.5%,,"负")&TEXT(INT(FIXED(ABS(A2))),"[dbnum2]")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]元-0.5%,,"负")&IF(ABS(A2)+0.5%<1,,TEXT(INT(ABS(A2)+0.5%),"[dbnum2]")&"元")&TEXT(RIGHT(FIXED(A2),2)-0.5%,,"负")&IF(INT(ABS(A2)+0.5%)<1,,NUMBERSTRING(INT(ABS(A2)+0.5%),2)&"元")&TEXT(RIGHT(FIXED(A2-0.5%,,"负")&IF(INT(ABS(A2)+0.5%),NUMBERSTRING(INT(ROUND(ABS(A2),2)),2)&"元",)&IF(MOD(ROUND(ABS(SUBSTITUTE、TEXT函数及[dbnum2]格式3SUBSTITUTE、TEXT函数及[dbnum2]格式4负贰佰伍拾捌元贰角柒分负贰佰伍拾捌元贰角柒分贰佰伍拾壹元零伍分贰佰伍拾壹元零伍分壹拾贰万伍仟玖佰捌拾柒元玖角壹拾贰万伍仟玖佰捌拾柒元玖角贰佰陆拾捌元零柒分贰佰陆拾捌元零柒分负壹元整负壹元整捌角叁分捌角叁分玖角整玖角整194196元;;")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]0角0分;;"&IF(ABS(A2)>1%,"整",)),"零角",IF(ABS(A2)<1,,"零")式元;;")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]0角0分;;"&IF(ABS(A2)>1%,"整",)),"零角",IF(ABS(A2)<1,,"零2]")&TEXT(RIGHT(FIXED(A2),2),"[dbnum2]元0角0分;;元"&IF(ABS(A2)>1%,"整",)),"零角",IF(ABS(A2)<1,,"零...
