ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¦³Ãö¼Æ¦rÂন¤é´Á®æ¦¡

[µo°Ý] ¦³Ãö¼Æ¦rÂন¤é´Á®æ¦¡

¨Ò¦p¡G
1000103
¿é¤J¤½¦¡=DATEVALUE(LEFT(D211,2)&"/"&MID(D211,4,2)&"/"&RIGHT(D211,2))
µ²ªG¥X¨Ó¬O10/1/3
¦ý§Ú­nªº¬O100/1/3
½Ð°Ý³o¤½¦¡¬O§_¦³¨º¸Ì»Ý­n­×§ïªº?!
ÁÂÁÂ^^

=TEXT(DATEVALUE(SUBSTITUTE(TEXT(A1+19110000,"00-00-00"),"-","/")),"e/m/d")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

±q¨Ó¨S¦³¥Î¹L¡B·Q¹LTXET³ºµMÁÙ¥i¥H¦p¦¹Âà´«
EXCEL»¡©ú¡B¨ç¼Æ¦r¨å¤W³£¬d¤£¨ìªº
¤S¦h¾Ç¨ì¤F
ASUS

TOP

ÁÂÁª©¤jªº«ü¾É
¥i¤£¤F¸Ñªº¬O¬°¦ó­n¥[¤Wtext
ÁÙ¦³§Ú­ì¦³ªº¤½¦¡¬O§_´N¤£¾A¥Î¤F©O?!
¦]¬°§Ú¦³­pºâ¦~¸êªº°ÝÃD
°ò·Ç¤é¬O³]99/12/31(ÁöÅã¥Ü¬O³o¼Ë¡A¦ý¬O¹ê»Ú¼Æ¦r«o¬O1999/12/31)
§Ú°ò·Ç¤é§ï¦¨2010/12/31¡AÅã¥Ü99/12/31
³o¼Ë©Ò¦³¦~¸ê­pºâ³£¤£¹ï¤F= ="
§Úªº­pºâ¤½¦¡¬O³o¼Ë
=DATEDIF(E153,$N$2+1,"y")&"¦~"&DATEDIF(E153,$N$2+1,"ym")&"¤ë"&DATEDIF(E153,$N$2+1,"md")&"¤Ñ"
§Ú­n«ç»ò­×§ï¤~¹ï©O~_~

TOP

¥Á°ê¸ò¦è¤¸¤£¦P
=DATEVALUE(SUBSTITUTE(TEXT(A1+19110000,"00-00-00"),"-","/"))
¥H¤W¤½¦¡´N·|Âন¥¿½T¤é´Á§Ç¦C¼Æ
§Q¥Î®æ¦¡¦Û­q"e/m/d"´N·|Åã¥Ü¥Á°ê¦~¤ë¤é¡A¦ý­È¬O¥¿½Tªº¦è¤¸¤é´Á
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

­ì¨Ó¦p¦¹°Ú~~
§Úªº°ÝÃD¸Ñ¨M¤F
·PÁª©¤jªº«ü¾É^^

TOP

«z¡I¦n¸Ô²Ó  §Ú¦b¿é¤J¸ê®Æ  ¥Á°ê©M¦è¤¸  ±`±`µLªk¸Ñ¨M  ¦]¬°§Ú³£¥ÎÀx¦s®æ®æ¦¡  ¸Ì­±ªº¼Æ­È¤¤ªº¤é´Á  ¦³®É«Ü®ð µLªk¨Ï¥Î§Ú­nªº¼Æ­È  ÁÂÁ  ¾Ç°_¨Ó

TOP

EXCEL ªº¨ç¦¡¸ÑÄÀ¨Ã¤£¬O«Ü²M·¡,¨Æ¹ê¤WDATEVALUE±µ¨ü
=DATEVALUE(TEXT(A1+19110000,"0000-00-00"))ªº®æ¦¡

TOP

¯u¬O¸Ñ¨M§Úªº§x´o ¶V¾Ç¶V¦nª±³á

TOP

=--TEXT(A1+19110000,"0000-00-00")
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD