如题所述
æ¯è¾å®ç¾çæ¯è¿ä¸ªï¼
=SUBSTITUTE(SUBSTITUTE(IF(-RMB(A1),IF(A1>0,,"è´")&TEXT(INT(ABS(A1)),"[dbnum2]G/éç¨æ ¼å¼å ;;")&TEXT(RIGHT(RMB(A1,2),2),"[dbnum2]0è§0å;;æ´"),),"é¶è§",IF(A1^2<1,,"é¶")),"é¶å",)
æA1åå æ ¼çéé¢è½¬æ¢æ大åï¼å å«å è§åççã
=SUBSTITUTE(SUBSTITUTE(IF(-RMB(A1),IF(A1>0,,"è´")&TEXT(INT(ABS(A1)),"[dbnum2]G/éç¨æ ¼å¼å ;;")&TEXT(RIGHT(RMB(A1,2),2),"[dbnum2]0è§0å;;æ´"),),"é¶è§",IF(A1^2<1,,"é¶")),"é¶å",)
æA1åå æ ¼çéé¢è½¬æ¢æ大åï¼å å«å è§åççã
温馨提示:答案为网友推荐,仅供参考
第1个回答 2016-12-22
如A1单元格为121元,B1单元格可输入=TEXT(A1,"[dbnum2]0佰0十0元")