é±ä¸æ¯ä¸è½çï¼ä½æ²¡é±æ¯ä¸ä¸ä¸è½çãè½ç¨é±è§£å³çé®é¢ï¼å°±é½ä¸æ¯å¤§é®é¢ã
æ¬èå°ç¦å¸¦å¤§å®¶æ¢ç´¢éé¢è½¬æ¢æ大åéé¢çæ¹æ³
å ä»ç»ä¸¤ç§å¯ä»¥å°æ°å转æ¢æ大åçæ¹æ³æå·§
1è°æ´æ ¼å¼
éè¿è®¾ç½®åå æ ¼æ ¼å¼-ç¹æ®-ä¸æ大åæ°å
å°A2åå æ ¼ç12800ï¼è½¬æ¢ä¸ºï¼å£¹ä¸è´°ä»æä½°
å°A3åå æ ¼ç88.8ï¼è½¬æ¢ä¸ºï¼ææ¾æ.æ
2使ç¨å½æ°æ³
æ们使ç¨NUMBERSTRING(A2,2)å ¬å¼
å°å°åæ°ååæ ·ç转æ¢æäºå¤§åæ°åã
å½éå°å°æ°ç¹æ¶ï¼ä¼å å°å°æ°ç¹åèäºå ¥ææ´æ°
ç¶ååè¿è¡è½¬æ¢æ大å
æ以88.8转æ¢æ¶åæäº89ç大åææ¾çã
æ们åç°
使ç¨è¿ä¸¤ç§æ¹æ³è½ç®åçå°æ°å转æ¢æ大å
ä½é½æ²¡è½å®ç°åãè§ãåçä½ç°ã
ä¸é¢ä»ç»ä¸¤ç§æ¹è¿æ¹æ³ã
ä¸ãTEXT
=TEXT(INT(A2),[DBNUM2])å TEXT(MID(A2,LEN(INT(A2))+2,1),[DBNUM2]Dè§
)TEXT(MID(A2,LEN(INT(A2))+3,1),[DBNUM2]Då)æ´
äºãNUMBERSTRING
=NUMBERSTRING(A2,2)å NUMBERSTRING(INT(A2*10)-INT(A2)*10,2)è§NUMBERSTRING(ROUND(INT(A2*100)-INT(A2*10)*10,0),2)åæ´
è¿ä¸¤ç§æ¹æ³é½ä¸ç¨è®°ï¼éè¦ç¨çæ¶åç´æ¥å¤å¶ç²è´´ä½¿ç¨å³å¯ï¼å°åå æ ¼å¼ç¨è¿è¡æ´æ¢ï¼æ¨è使ç¨ç¬¬ä¸ç§TEXTæ¹æ³ã