Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Quick way to insert date into Excel (2003)

    What is the quickest way to put a date into a cell into Excel,obviously l could type the date out, but is there an option like in Word to automatically insert the date without typing it out.
    See screenshot for date format l require.

  2. #2
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick way to insert date into Excel (2003)

    Hold down the Ctrl key and press ; (semicolon) to insert today's date.
    (Holding down Shift as well will insert the current time).
    Waggers
    If at first you do succeed, you've probably missed something.

  3. #3
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Quick way to insert date into Excel (2003)

    Thanks for that, that

Posting Permissions

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