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

[µo°Ý] ½s¿è¦C¡m¤£­nÅã¥Ü¡n¬P´Á§O

[µo°Ý] ½s¿è¦C¡m¤£­nÅã¥Ü¡n¬P´Á§O

¥»©«³Ì«á¥Ñ papaya ©ó 2020-12-4 18:16 ½s¿è


1_AÄ檺¤é´Á¦³¬P´Á§O¡A¦ý½s¿è¦C¤£·|Åã¥Ü¥X¬P´Á§O¡C
2_AÄ檺¤é´Á¡A¤â°ÊÅܧó¡A«öEnter«á¡A·|¦Û°Ê§ó·s¬°¥¿½Tªº¬P´Á§O¡C
¦³À˵øAÄæÀx¦s®æªº®æ¦¡¬O¦Û­q¬° yyyy/m/d (aaa)

·QÅýDÄ檺Àx¦s®æ®æ¦¡¤]¦³AÄæÀx¦s®æªº²Ä1,2¶µ¥\¯à¡A
¦ý±NDÄ檺Àx¦s®æ®æ¦¡¤]¦Û­q¬° yyyy/m/d (aaa)«á~«oµL®Ä~½Æ»sAÄæ®æ¦¡¤]¬OµL®Ä^^¡¨

½Ð°Ý :
DÄ檺Àx¦s®æ®æ¦¡­n¦p¦ó¾Þ§@¡H

´ú¸ÕÀÉ : ¤£­nÅã¥Ü¬P´Á§O.rar (1.79 KB)

¦^´_ 1# papaya


    ½Æ»sAÄæ«á-->¦ÜDÄæÀx¦s®æ («ö·Æ¹«¥kÁä) --->¿ï¾Ü"¶K¤W¤½¦¡"

¤£­nÅã¥Ü¬P´Á§O.jpg (67.43 KB)

¤£­nÅã¥Ü¬P´Á§O.jpg

TOP

¦^´_ 1# papaya

¦ý±NDÄ檺Àx¦s®æ®æ¦¡¤]¦Û­q¬° yyyy/m/d (aaa)«á~«oµL®Ä~½Æ»sAÄæ®æ¦¡¤]¬OµL®Ä^^¡¨
½Ð°Ý :DÄ檺Àx¦s®æ®æ¦¡­n¦p¦ó¾Þ§@¡H
   >> Ctrl + C --> Ctrl + V  ¡A ½Ð¦A´ú¸Õ¬Ý¬Ý¡AÁÂÁ¡C

Â^¨ú.PNG (40.03 KB)

Â^¨ú.PNG

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2020-12-11 09:45 ½s¿è

¦^´_ 2# ABK
¦^´_ 3# samwang
·PÁ¤G¦ì¤j¤jªº¸Ñµª¡C±z­Ìªº¤èªk³£¥i¥H¥Î¡AÁÂÁÂ!

¥u¬O§Úªº¥D­n­«ÂI¬O§Æ±æDÄæ¯à¥H"¥\¯àÁä"¨Ó¹F¦¨¦pAÄ檺½s¿è¦C¡m¤£­nÅã¥Ü¡n¬P´Á§O(EX¤G)¡A(¤­))~ ¤£ª¾¹D¥i¦æ?~
§Y¬O»¡ :"°²³]¨S¦³AÄ檺¨Ó·½©M¤]¤£­n¦b¥¦Äæ¥Î¤½¦¡Åã¥Üµª®×"¡A¦A¦^¶KDÄæ¡C

ÁÂÁ¤G¦ì¤j¤j

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2020-12-12 00:25 ½s¿è

¦^´_ 4# papaya

¥u¬O§Úªº¥D­n­«ÂI¬O§Æ±æDÄæ¯à¥H"¥\¯àÁä"¨Ó¹F¦¨¦pAÄ檺½s¿è¦C¡m¤£­nÅã¥Ü¡n¬P´Á§O(EX¤G)¡A(¤­))~ ¤£ª¾¹D¥i¦æ?~
§Y¬O»¡ :"°²³]¨S¦³AÄ檺¨Ó·½©M¤]¤£­n¦b¥¦Äæ¥Î¤½¦¡Åã¥Üµª®×"¡A¦A¦^¶KDÄæ¡C

¥ý¿ï¾Ü§A­n§ïªºÀx¦s®æ¡A«ö§Ö±¶  Ctrl+Shift+F

´N·|§â¸Ó¤å¦r®æ¦¡§ï¦¨¤é´Á®æ¦¡¡Aªþ¥ó¦p¤U¡A°Ñ¦Ò¬Ý¬Ý


¤£­nÅã¥Ü¬P´Á§O(Ctrl+Shit+F).rar (9.72 KB)
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2020-12-12 06:27 ½s¿è

¦^´_ 2# ABK
¦^´_ 3# samwang

Sorry~§Ú¨S¦³±N¥DÃD»Ý¨D§@§¹µ½ªº»¡©ú¡A¯Ô»~¤G¦ì¤j¤jªºÄ_¶Q®É¶¡~©|½Ð¨£½Ì

¦A¦¸ÁÂÁ¤G¦ì¤j¤j

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2020-12-12 06:29 ½s¿è

¦^´_ 5# n7822123
»~·|¤j¤F~
­ì¨Ó¬OÂ泥Ⱦ÷~ÁÙ¥H¬°¤§«e¤U¸ü¶Q¸ÑµªÀɮפºªºDATA!¤é´ÁÄæ¸ê®Æ¬O¥u­n¥H¤u¨ãÁä´N¯à¹F¦¨

´ú¸ÕOK~ÁÂÁ±z

TOP

¦^´_ 7# papaya


DÄ檺¤é´Á§t¦³CHRW(160)¤£¥i¨£¦r¤¸, ¥B¬°¤å¦r¤£¬O¼Ð·Ç¤é´Á,
¥ÎAÄæ¨ê®æ¦¡¤@©w¨S¥Î, ¨­Å餣§ïÅÜ, ´«¦çªA¦ó¥Î??? ³o¬O°ò¥»±`ÃÑ~~
Sub TTT()
With Range("D:D")
     .NumberFormatLocal = "yyyy/mm/dd (aaa)"
     .Replace ChrW(160) & "*", "", lookat:=xlPart
End With
End Sub

TOP

¥»©«³Ì«á¥Ñ papaya ©ó 2020-12-14 13:18 ½s¿è

¦^´_ 8# ­ã´£³¡ªL
­ã´£ª©¥D:·íªì¥u¬O±Nn¤j¦^µªÀÉDATA!ªº¤é´Á¤º®eCOPT¨ì·s¼Wªº¤u§@ªíªº¤é´Á¤º®eCOPY¨ì·s¼Wªº¤u§@ªí¤¤¡A
°¸µMµo²{COPY¨Óªº¸ê®Æ¡A¦b½s¿è¦C¤£·|Åã¥Ü"¬P´Á§O"¡A¬d¬Ýµ²ªG¬O¥u¦³Àx¦s®æ®æ¦¡¦Û­q¬°yyyy/m/d (aaa)
¨Ã¨S¦³¬Ý¨ì¦³¤½¦¡©Îµ{¦¡½X¡A©Ò¥H§Ú¤~·|²§·Q¤Ñ¶}¥H¬°¥u­n¾Þ§@¥\¯àÁä¡A´N¥i¥H¹F¨ì»Ý¨D¤F


¶Qµ{¦¡¸Ñµª¡A§Ú·|¥J²Ó¬ã²ß~
ÁÂÁ±zªº¤£§[«ü¾É~·P®¦

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD