Results 1 to 4 of 4

Thread: Year Change

  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

    Year Change

    I've got about 5 sheets of data that I need to enter into a spreadsheet. Problem is all of the data is from 2015. Is there a way or formula I can enter so that it will populate 2015 instead of 2016. I looked at the customs but didn't see anything there

    Thanks
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    ..have you thought about possibly using [Ctrl][H] to do a global replace??

    zeddy

  3. The Following User Says Thank You to zeddy For This Useful Post:

    t8ntlikly (2016-04-10)

  4. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts
    To be honest, I didn't even know about that. Tried it and that will work. Great tip! thanks
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  5. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts
    Another approach, although a little bit more dangerous, is to change your system clock to be sometime in 2015. Doesn't matter when. I've done that on a few occasions. BUT YOU HAVE TO REMEMBER TO CHANGE IT BACK. On some computers, you may also need admin rights to do that (when a dialog pops up, just put in the admin password).

    Fred

Posting Permissions

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