州治
六种人民币大写数字相互转换及新增人民币写法三种
公式长度168=SUBSTITUTE(IF(-DOLLAR(A2),IF(A2>0,,"负")&TEXT(INT(ABS(A2)+0.5%),167=SUBSTITUTE(SUBSTITUTE(IF(-DOLLAR(A2),IF(A2>0,,"负")&TEXT(INT(ABS187=SUBSTITUTE(IF(-RMB(A2),IF(A2>0,,"负")&...
公式长度168=SUBSTITUTE(IF(-DOLLAR(A2),IF(A2>0,,"负")&TEXT(INT(ABS(A2)+0.5%),167=SUBSTITUTE(SUBSTITUTE(IF(-DOLLAR(A2),IF(A2>0,,"负")&TEXT(INT(ABS187=SUBSTITUTE(IF(-RMB(A2),IF(A2>0,,"负")&...