Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Insertion of date into cell (2000)

    I would like to insert the date in the format "Sept-05' into a cell.
    What is the easiest way to do this?
    Rather than keep tying it in all the time.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Insertion of date into cell (2000)

    If you format the cell or cells as mmm-yy, you only need to press Ctrl+; (that is Control+Semicolon) and press Enter. The format will be Sep-05, Windows doesn't have a built-in format that displays the month as Sept.

Posting Permissions

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