B2å ¬å¼ï¼=IF(A2>=10000,LEFT(RIGHT(TEXT(A2,"0.00"),8),1),"")
C2å ¬å¼ï¼=IF(A2>=1000,LEFT(RIGHT(TEXT(A2,"0.00"),7),1),"")
D2å ¬å¼ï¼=IF(A2>=100,LEFT(RIGHT(TEXT(A2,"0.00"),6),1),"")
E2å ¬å¼ï¼=IF(A2>=10,LEFT(RIGHT(TEXT(A2,"0.00"),5),1),"")
F2å ¬å¼ï¼=IF(A2>=1,LEFT(RIGHT(TEXT(A2,"0.00"),4),1),"")
G2å ¬å¼ï¼=IF(A2*10>=1,LEFT(RIGHT(TEXT(A2*10,"0.00"),4),1),"")
H2å ¬å¼ï¼=IF(A2*100>=1,LEFT(RIGHT(TEXT(A2*100,"0.00"),4),1),"")
ç¶åå¾ä¸æå°±è¡äº
åçå°±æ¯å å°å·¦åçé±æ°è½¬æ¢æä¿ç两ä½å°æ°çææ¬(TEXTå½æ°)ï¼ç¶åå¤æé±æ°ç大å°ï¼å¦æé±æ°å°äºä¸ä¸ï¼åä¸ä½ç0ä¸æ¾ç¤ºï¼å°æ°é¨åèèå°ä¼åèäºå ¥ï¼æ以éè¦å°å ¶ä¹ä»¥10æ100ï¼ç¶åæªå个ä½ã
千位数提取: =RIGHT(INT(A2/1000))
万位数提取: =RIGHT(INT(A2/10000))
不足位,自动为0,不过这组数字要为正数或0.负数会出错。