Óû§Ãû£ºÅ¼È»éÐýˆñR
Ò»¡¢·½·¨Õ¹Ê¾
C2µ¥Ôª¸ñÊäÈ빫ʽ£º=--TEXT(MID(B2,7,8),"0-00-00")£¬Ïòϸ´ÖÆÌî³ä¡£Ò»´ÎÐÔÌáÈ¡ËùÓÐÉí·ÝºÅÂë¶ÔÓ¦µÄ³öÀ´×ÔÉúÈÕÆÚ¡£
¶þ¡¢¹«Ê½½âÊÍ£º
£¨1£©ÏÈ¿´MIDº¯Êý£ºMID(B2,7,8)µÄÒâ˼¾ÍÊÇ´ÓB2µ¥Ôª¸ñµÄµÚ7λ¿ªÊ¼½ÅÑØ½ÏÐг¤Çó½ØÈ¡£¬½ØÈ¡µÄ×Ö·û³¤¶ÈÊÇ8룬µÃµ½µÄ¼ÆËã½á¹û¾ÍÊÇ"19761204"¡£
£¨2£©½ÓÏÂÀ´ÓÃTEXTº¯Êý£¬½«MIDº¯ÊýµÃµ½µÄ×Ö·û´®±ä³ÉÈÕÆÚµÄÄ£Ñù£¬TÁª¸£ÒòEXT(MID(B2,7,8),"0-00-00ÊÂ")½«Îı¾×Ö·û´®"19761204"´ÓÓÒ²àµÄµÚ¶þλºÍµÚËÄλ֮¼ä¸÷¼ÓÉÏÒ»¸ö¶ÌºáϬ½á¹û±ä³É331215ÎÊ´ð"1976-12-04"¡£
£¨3£©¾¹ýtextº¯ÊýÇÇ×°´ò°ç£¬Îı¾×Ö·û´®"19761204±ãºú¹ýÈ«ÀÏ"¾ÍÓÐÁËÈÕÆÚµÄÑù×ÓÁË£¬µ«ÊÇÕâÑùµÄ½á¹û½ö½öÊǺ¬¹Ìë֪¶ÈÊ¼ÔøÑÚÈ˶úÄ¿£¬»**»ÊÇÕæÕýµÄÈÕÆÚ¸ñ½ÇÉýÍþÈñà¸ùÖ³ÏòÕßʳʽ¡£ExcelÖз²ÊǾ¹ýTEXT¡¢MID¡¢LEFT¡¢RIGh**TµÈº¯Êý¼Æ×éÈÈËãºóµÃ³öµÄÊýÖµÊÇÎı¾¸ñʽ£¬Ò»°ãÁ¬Ãü³åËÕ¸ïÔ²Ó¢Çé¿öÏ£¬²»ÄܲÎÓëºóÐøµÄ¼ÆËã´¦Àí¡£