如题所述
1.æ¯å¦ä»å¤©æ¯2010å¹´9æ2æ¥ï¼ç¨ä»¥ä¸å ¬å¼å°±å¯ä»¥å¾åºååä¸æäºååï¼
2.è½ç¶å¨éå°é°ææ¶ï¼æ¾ç¤ºç»ææç¹å·®å¼ºäººæï¼å¦ä¸å¾ä¸ï¼2010å¹´2æ9æ¥çåååºæ¯åäºæäºåå ï¼ä½å 为é£å¹´æ个é°äºæï¼å°±æ è¾å¤åºæ¥ä¸ä¸ªæäºãä¸è¿æ»æ¯ç¼ä»£ç è¦å¿«æ·å¤äºå§ï¼èä¸é°æä¹ä¸æ¯å¤©å¤©æã
3.åå¦æå
¬å¼æ¹æï¼=MID("ç²ä¹ä¸ä¸æå·±åºè¾å£¬ç¸",MOD(TEXT(A2,"[$-130000]e")-4,10)+1,1)&MID("åä¸å¯
å¯è¾°å·³åæªç³é
æ亥",MOD(TEXT(A2,"[$-130000]e")-4,12)+1,1)&"å¹´"&TEXT(A2,"[$-130000][DBNum1]mæ")&TEXT(A2,IF(--TEXT(A2,"[$-130000]d")=10,"åå",IF(--TEXT(A2,"[$-130000]d")>10,"[$-130000][DBNum1]d","å[$-130000][DBNum1]d")))ï¼é£å°±æ´ååå表示æ³äºï¼ä¸è¿å 为ååæ¯å¹´å¼å§æ¥æé½ä¸ä¸æ ·ï¼æ以å½æ°å¾é¾è¾¾å°åå精确çç»æï¼åªè½æ¯å°å°±çç¨ã
ããé£å°±æ´åååç表示æ³äºã