Results 1 to 2 of 2
  1. #1

    Default Auto insert static date in Excel 2002

    Is there a way to auto insert a static date in Excel 02 like you can in Word? Have tried +TODAY() and the date option in header but if it's opened on a future date it shows that date.
    Need it for a statement date so it has to remain as originally auto-inserted.
    Hope you can help.

  2. #2

    Default Re: Auto insert static date in Excel 2002

    Hi, there is no autoinsert as such but you can use shortcut keys.

    Click in the cell you want the date then press the CTRL & ; keys (both keys at once)

Similar Threads

  1. PHP MYSQL insert Date
    By Morgenmuffel in forum PressF1
    Replies: 7
    Last Post: 18-12-2004, 04:18 PM
  2. Word 2003 date insert
    By sam m in forum PressF1
    Replies: 5
    Last Post: 16-11-2004, 08:48 AM
  3. Batch file to insert date
    By Spartacus in forum PressF1
    Replies: 8
    Last Post: 12-08-2004, 02:12 PM
  4. Word 2002-insert file name & path
    By in forum PressF1
    Replies: 2
    Last Post: 13-05-2002, 12:26 AM
  5. cd auto insert win98
    By in forum PressF1
    Replies: 0
    Last Post: 27-09-2000, 07:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts