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

¦P¼Ë»yªk¦bXP, WIN7 ¤é´Á®æ¦¡¤£¦P??

¥»©«³Ì«á¥Ñ luhpro ©ó 2014-12-10 22:04 ½s¿è
[a1]= Format(Date, "eemmdd")
XP ==>1031210
WIN7=>20141210
¨D±oªºµª®×¤£¦P???
¬°¦ówin7 ¬O¥Î "yyyym ...
t8899 µoªí©ó 2014-12-10 21:48

§Úªº¬O Win7 + Office2003
°õ¦æ¸Ó«ü¥O±o¨ìªº¬O 1031210 ³á.

§Ú²q¬O A1 Àx¦s®æªº NumberFormat ¨Ã«D¬O "General",
¸Õ¸Õ¬Ý§ï¥H¤U¤è¦¡½á­È:
  With [A1]
    .NumberFormat = "eemmdd"
    .Value = Now
  End With

Format ¨ç¼Æ¸û¾A¥Îªº¹ï¶H¬O "ÅܼÆ" .

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD