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

t8899

[a1]= Format(Date, "eemmdd")
XP ==>1031210
WIN7=>20141210
¨D±oªºµª®×¤£¦P???
¬°¦ówin7 ¬O¥Î "yyyymmdd" ???

t8899

­^¤åª©ªº Win7 (¦h°ê»y¨¥) => 20141210
¤¤¤åª©ªº Win7 => 1031210
¤w¸Õ¹L³oµª®×¬O¥¿½T

t8899

­^¤åª©ªº Win7 => 20141210
¤¤¤åª©ªº Win7 => 1031210
diabo µoªí©ó 2014-12-11 15:28

¥S¥x¨â­Óª©¥»³£¦³´ú¸Õ¹L???Ãø¹D§Úªº¬O­^¤åª©???

diabo

­^¤åª©ªº Win7 => 20141210
¤¤¤åª©ªº Win7 => 1031210

ashan0418

¦^´_ 1# t8899


§Úªº¬O Win7 + Office2010

±o¨ìªº¬O 1031211

t8899

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

§Ú²q¬O A1 Àx¦s®æªº NumberFormat ¨Ã«D¬O ...
luhpro µoªí©ó 2014-12-10 22:03

§Ú¬O¥Î¦P¤@­ÓÀÉ®×¥h´úªº!

luhpro

[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 "ÅܼÆ" .