=IF(ABS(A2)0.005,,IF(A20,负,)[dbnum2])元,)[dbnum2])角,IF(INT(ABS(A2))=ABS(A2),,IF(ABS(A2)0.1,,零)))[dbnum2])分,整))=IF(A2=0,零,IF(A2-0.5%,,负)[dbnum2]G/通用格式元;;)[dbnum2]0角0分;;),零角,IF(ABS(A2)1,,零)),零分,整))=IF(A10,负,)元[dbnum2]0角0分)=IF(COUNT(FIND(亿,B2)),SUM(TEXT(FIND(MID(B2,FIND({亿,拾,佰,仟},B2整拾佰仟)⑴,1),拾佰仟整壹贰叁肆伍陆柒捌玖)⑷,0;!0)*10^{8,9,10,11}*(FIND({亿,拾,佰,仟},B2拾佰仟)=FIND(亿,B2))))+IF(COUNT(FIND(万,B2)),SUM(TEXT(FIND(MID(B2,FIND({万,拾,佰,仟},B2整拾佰仟,IF(FIND(亿,B2亿)LEN(B2),FIND(亿,B2),1))⑴,1),拾佰仟整壹贰叁肆伍陆柒捌玖)⑷,0;!0)*10^{4,5,6,7}*(FIND({万,拾,佰,仟},B2拾佰仟,IF(FIND(亿,B2亿)LEN(B2),FIND(亿,B2),1))=FIND(万,B2))))+SUM(TEXT(FIND(MID(MID(B2,MAX((FIND({万,亿},B2万,亿})LEN(B2))*FIND({万,亿},B2万,亿}),1),99)分角元拾佰仟,FIND({分,角,元,拾,佰,仟},MID(B2,MAX((FIND({万,亿},B2万,亿})LEN(B2))*FIND({万,亿},B2万,亿}),1),99)分角元拾佰仟)⑴,1),拾佰仟万亿元角分整壹贰叁肆伍陆柒捌玖)⑼,0;!0)*10^{⑵,⑴,0,1,2,3})
温馨提示：答案为网友推荐，仅供参考