大å°å转æ¢çå¸åæ¯è¾å¤ï¼ç¾åº¦ä¸ä¸è½æ¾å°å¾å¤ãä¸é¢ç»ä½ ä¸ä¸ªè½¬æ¢çå
¬å¼ï¼
=IF(ABS(A2)<0.005,"",IF(A2<0,"è´",)&IF(INT(ABS(A2)),TEXT(INT(ABS(A2)),"[dbnum2]")&"å
",)&IF(INT(ABS(A2)*10)-INT(ABS(A2))*10,TEXT(INT(ABS(A2)*10)-INT(ABS(A2))*10,"[dbnum2]")&"è§",IF(INT(ABS(A2))=ABS(A2),,IF(ABS(A2)<0.1,,"é¶")))&IF(ROUND(ABS(A2)*100-INT(ABS(A2)*10)*10,),TEXT(ROUND(ABS(A2)*100-INT(ABS(A2)*10)*10,),"[dbnum2]")&"å","æ´"))"
å
¬å¼ä¸æ¯å设å°åæ°åå¨A2åå
æ ¼ä¸ï¼å¦ææ°æ®ä¸æ¯A2åå
æ ¼ï¼èæ¯å¨B5åå
æ ¼ï¼åè¦å°å
¬å¼ä¸çææA2é½ä¿®æ¹æB5ï¼å
¶ä»ç±»æ¨ã
温馨提示:答案为网友推荐,仅供参考