ÈçºÎÓÃexcelÌáÈ¡Éí·ÝºÅÖеÄÉúÈÕ

ʱ¼ä£º2016.08.15 ·¢²¼ÈË£ºoma347h2

ÈçºÎÓÃexcelÌáÈ¡Éí·ÝºÅÖеÄÉúÈÕ

Òѽâ¾öÎÊÌâ

¹È¸èoma347h2Óû§ÔÚ2016.08.15Ìá½»Á˹ØÓÚ¡°ÒÁ¹ÏËÕ´óÆÙ²¼ÈçºÎÓÃexcelÌáÈ¡Éí·ÝºÅÖеÄÉúÈÕ¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2024-11-09T05:44:00¡£Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÆÚ´ýÄúµÄ´ð°¸£¬ÕæÐÄÅå·þÄã,лл £¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºrtyhqee63  

¡°ÈçºÎÔÚExcelÖÐÌáÈ¡Éí·ÝºÅÖеÄÉúÈÕ¡±²Ù×÷²½ÖèÈçÏ£º

1¡¢Ê×ÏÈ£¬´ò¿ªÄúµÄExcel¹¤×÷±í£»

2¡¢¼ÙÉèBÁаüº¬ÁËÒÔÎı¾¸ñʽ³ÊÏÖµÄÉíί×ŷݺÅÂë¡£¸ù¾ÝÉí·ÝºÅÂëµÄ±àÂë¹æÔò£¬³öÉúÈÕÆÚ±àÂëÊÇ´ÓµÚ7λÎÊ´ð¿ªÊ¼µÄ8¸ö×Ö·û¡£Äú¿ÉÒÔʹÓôðÇúÁÒMIDº¯ÊýÀ´ÌáÈ¡Õⲿ·ÖÐÅÏ¢£¬²¢½«Æäת»»ÎªÈÕÆÚ¸ñʽ¡£

3¡¢ÔÚC2µ¥Ôª¸ñÖÐÊäÈëÒÔϹ«Ê½£¬²¢ÏòÏÂÌî³äÒÔÓ¦Óõ½ÆäËûµ¥Ôª¸ñ£º

=TEXT(MID(B2,7,8),"0-00-00")

Õâ¸ö¹«Ê½µÄ×÷ÓÃÊÇ´ÓB2µ¥Ôª¸ñµÄµÚ7¸ö×Ö·û¿ªÊ¼ÌáÈ¡8¸ö×Ö·û£¬²¢ÒÔ¡°0000-00-00¡±µÄ¼ÊËÀ¸ñʽÏÔʾΪ³öÉúÈÕÆÚ¡£

4¡¢ÉÏÊö²½ÖèµÃµ½µÄÊÇÒÔ¡°0000-00-00¡±¸ñʽÏÔʾµÄÈÕÆÚ**£¬µ«»**»ÊÇ¿ÉÒÔÖ±½Ó¼ÆËãµÄÈÕÆÚ¸ñʽ¡£ÈôÐèҪת»»Îª¿É¼ÆËãµÄÈÕÆÚ£¬ÄúÐèҪѡÔñCÁУ¬Í¨¹ý¡°ÉèÖõ¥Ôª¸ñ¸ñʽ¡±½«**¸ñʽÉèÖÃΪ¡°ÈÕÆÚ¡±¡£È»ºóÔÚC²ßȺ·ÊÀ­½ð2µ¥Ôª¸ñÊäÈëÒÔϹ«Ê½£¬²¢ÏòÏÂÌî³ä£º

=--TEXT(MID(B2,7,8),"0-00-00")