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

¨Ï¥Î TODAY() ¨ú±o¨t²Î¤é´Á µM«á©T©w¤£ÅÜ «ç¼Ò°µ©O

¦^´_ 20# mycmyc


    ­ì¤å
http://excel.bigresource.com/Lock-in-TODAY-date-r78wMVvM.html

I have since eliminated the function and just type in the date to avoid this but I have about 100 invoices that are saved that I may need to view their "original" dates on.
Now when I need to go back and look at the old invoice or print it again it shows the CURRENT date, not the original date when it was saved. Is there a way to view and/or print out a file while keeping the original date intact or is there a better way to format a date to avoid this happening in the future.
½Ķ
http://translate.google.com/translate?hl=zh-TW&sl=en&u=http://www.excelforum.com/excel-general/677762-today-function-and-viewing-or-printing-original-date.html&prev=/search%3Fq%3DUse%2BTODAY%2B()%2Bto%2Bobtain%2Bthe%2Bsystem%2Bdate%2Band%2Bthen%2Bfixed%26hl%3Dzh-TW%26sa%3DG&rurl=translate.google.com.tw&twu=1

µ²½×
No; you're going to have to correct the date manually, based on the previous file save date, or whatever other data you can resurrect.¤£¡A§A±N¤£±o¤£¤â°Ê§ó¥¿¤é´Á¡A®Ú¾Ú¥H«eªº¤å¥ó«O¦s¤é´Á¡A©Î¥ô¦ó¨ä¥L¼Æ¾Ú¡A¥i¥H´_¬¡¡C
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

¦^´_ 21# PD961A
§ÚµLªk ¤U¸ü ¸ÓÀÉ®×
¦ý·N«ä¦n¹³¬OµLªk¨Ï¥Î TODAY()
¬O¶Ü  ÁÂÁ§A
HI

TOP

¦^´_ 22# mycmyc


    ¬Oªü
­ì¤åªº·N«ä¬O
¥Lªº»Ý¨D¬O·í¤Ñ¥Î¢â¢Ý¢Ò¢Ï¢ç¦ý¬O­n©T©w
©¹«á°l¬d®Éµo²¼¤é´Á­n¯àÅã¥Ü·í¤é
¤é´Á©Ò¥H¦³ÂIÃø
­ì¤å¤º®e¤]¬O«Øij±z¥Îctrl+;
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

¦^´_ 23# PD961A

ctrl+;  À³¸Ó¬O·L³n ³]­p¤é´Á¤è¦¡
          ¦ý¥L¨S¦Ò¼{¨ì ¦pªG«OÅ@>>¦Û°Ê²£¥Í¤é´Á>>¤£µ¹¿é¤J
          ´NµLªk§Q¥Î¤½¥Ü ¥²¶·¥ÎVBA
HI

TOP

¦^´_  PD961A

ctrl+;  À³¸Ó¬O·L³n ³]­p¤é´Á¤è¦¡
          ¦ý¥L¨S¦Ò¼{¨ì ¦pªG«OÅ@>>¦Û°Ê²£¥Í¤é´Á>>¤£µ¹ ...
mycmyc µoªí©ó 2010-10-17 00:56



µoªí©ó ¬Q¤Ñ 10:52 | ¥u¬Ý¸Ó§@ªÌ
#19
®LªO¥D©Ò»¡   
Áä¤J10-16«öEnter
²³æ©ö¥Î
¥u¬O¥Î­Ó[¹Bºâ¤l]
/¤]¦æ


#15
OOBIRD ª©¥D¤]»¡
³Ì¦nÁÙ¬O¥Îctrl+;
¬°¤°»ò¤@©w­n¿é¤J¤½¦¡¡H¥u¬°¼W¥[§xÃø«×¡H§ïÅܤÏÂйBºâ·|¼vÅT©Ò¦³ªº¬¡­¶Ã¯¡C
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

¦^´_ 25# PD961A
   ¨ä¹ê§Ú·Qªk¬O  ¤é´Á¤£µ¹¿é¤JªÌ ¦^®Ò  ¥u¯à¿é¤J·í¤Ñ¤é´Á
   ¥u­n¥Øªº¦b±±ºÞ   ¨Ã¤£¬O¿é¤Jªk°ÝÃD
   ¦³¤@­Ó·Qªk
   VB¥i¥H¥s¥X¤@­Ó  ¤é¾äªí³æ    EXCEL ¥i¥H¹F¨ì¶Ü
HI

TOP

¦^´_ 27# mycmyc


    ¨ä¹ê¦pªG±z¯uªº°õµÛ©ó»Ý­n¥Î¨ìVBA¥h¸Ñ±zªº°ÝÃD
±z´N±N±zªº°ÝÃD
PO¨ìµ{¦¡°Ï¥hµo°Ý
¨Ã¸Ô²Ó»¡©ú±zªº»Ý¨D...¥B¤@©w­nªþ¤WÀÉ®×
³o¼Ë¥ý¶i¤Îª©¥D­Ì¤~¯à«Ü§Ö¶i¤Jª¬ªpÀ°±z¸ÑÃD

´N®LªO¥D¤ÎOOBIRDª©¥D©Ò»¡ªº¯à²³æ¤Æªº¦ó¥²½ÆÂø¤Æ©O?
±z´N¥[ªo§a.....
¾Ç¦p°f¤ô¦æ¦à ¤£¶i«h°h

TOP

¤w¸g»\¨ì27¼Ó¤F¡AÁÙ¬O¨S§ËÀ´¼Ó¥D¯u¥¿­nªº¬O¤°»ò¡C
§A¬O©È¥Îctrl+;¿é¤Jªº¤é´Á·|³Q§ó§ï¡H¨º«OÅ@¸ÓÀx¦s®æ´N¦æ¤F¡A­Y§A¤£°µ«OÅ@¡A¤£ºÞ¥Î¤½¦¡¡A¥Îvba¡A¥Î¤é¾ä±±¥ó¿é¤J³£¤@¼Ë·|³Q§ó§ïªº¡C¦P®É­n¥Î±±¥ó§A¥²¶·¾Ç·|vba»y¨¥¥h±±ºÞ¡I

TOP

ÁÂÁ oobird  PD961A ¤G¦ì¤j¤j
¿é¤Jªº¤é´Á·|³Q§ó§ï¡H¨º«OÅ@¸ÓÀx¦s®æ´N¦æ¤F  «OÅ@«á´N¨S¿ìªk ¿é¤J
©Ò¥H­n¥Î TODAY¡]¡^ ³o«K¶i¤J§Úªº¥DÃD
¨Ï¥Î TODAY() ¨ú±o¨t²Î¤é´Á µM«á©T©w¤£ÅÜ «ç¼Ò°µ©O
©Ó¦U¦ì«ü¾É
¤½¦¡¦]¸Ó¨S¸Ñ  ¥u¦n¨D§U VAB  ÁÂÁÂ
HI

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD