Results 1 to 5 of 5

Thread: Dates (MSO '07)

  1. #1
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Dates (MSO '07)

    I am entering some data this weekend from 2006. I have the date colum configured to show xx/xx/xx. I type in: xx/xx. The problem is because it is now 2007 the year also shows 07. Is there a way I can change that without having to type in the year as 06?
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Dates (MSO '07)

    Hi John

    Quick and dirty way is use Copy and Paste Special. In an empty cell type in 365, copy it to clipboard. Highlight the range you want to change, press Edit | Paste Special , highlight Subtract and then OK. You will then to reformat the range back to date format. Quick and dirty...an idea
    Jerry

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dates (MSO '07)

    You could change the system date to a date in 2006.
    Legare Coleman

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

    Re: Dates (MSO '07)

    Why not enter 12/14/06? It's not that much extra work, after all...

  5. #5
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Dates (MSO '07)

    No it isnt too much work to enter 2006, but I knew that there had to be another way to do this after I had all ready entered the data.
    Thanks Jezz. I did what you suggested and it worked perfectly. I didnt even have to reformat the cells.
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

Posting Permissions

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