¦U¦ì¤j¤j¦n
¤p§Ì¹J¨ì¤é´Á³B²z¤Wªº§xÃø
1.¦pªG¦bEXCEL¨Ï¥Î¦è¾ä¡A¨Ò¦p¦bA1¿é¤J2015/3/5¡A¨ºA1·|Åã¥Ü¦è¾ä¨S¿ù
¦Ó¥B¥i¥H¥ÎYEAR()¡BMONTH()µ¥¨ç¼Æ¶i¦æn¦h3Ӥ몺¹Bºâ
¨Ò¦pB1=YEAR(A1)&MONTH(A1)+3&DAY(A1)
¦n³B¬O¦pªG¤ë¥÷+3«á¡AÅܦ¸¦~¡A·|¦Û°Ê¶i¦ì
¦ý¬O¦pªG¦X¨Ö¦C¦L¨ìWORD¥h¡A©Î¬O¶×¤J¨ìACCESS¥h¡A·|Åܦ¨42068
³o¼Ë´N¨S»³¤F
2.¥t¥~¦pªGA1©ñ¤J1040305¡A³o¬O³q¥Î®æ¦¡¡A¦ý¬On¥[´î©Î§PÂ_¡A¤ñ¦pn±q³o¤Ñ¦h3Ó¤ë
§Ú´N±o¦bB2¡A©ñ¤J=MID(A1,1,3)&TEXT(MID(A1,4,2)+3,"00")&MID(A1,6,2)
¤]´N¬O·í¦¨¤å¦r¨Ó³B²z¡A³o¼Ë¦X¨Ö¦C¦L¨ìWORD´N¬O¥¿±`Åã¥Ü1040605
¥i¬O³o¤èªk´Nn¦Û¤v¥h¼gIF§PÂ_·|¤£·|¦³¹j¦~ªº°ÝÃD
¥H¤W¨âÓ°ÝÃD¬O§_¦³¸Ñ? ¤S¥i¥H¤è«K¨Ï¥Î¤é´Á®æ¦¡¥h°µ¹Bºâ¡A¦ý¤S¥i¥H¦X¨Ö¦C¦L©Î¶×¤JACCESS¤£·|¥X¿ùªº¤èªk?
ÁÂÁÂ |