Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Jun 2002
    Location
    RTP, NC, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Replacing Dates (Excel 97)

    I'm just trying to replace the 2003 with 2004 in a column of dates in my workbook...i have the cells formatted as date. I've tried Find/Replace and used "*/2003" as my find criteria and "*/2004" as my replace criteria, but that isn't working...any ideas on how i can accomplish a wholesale replace of all occurences of 2003 in the worksheet with 2004?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    Birmingham, West Midlands, United Kingdom
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replacing Dates (Excel 97)

    You mean, Marc, that as early as February you've stopped typing 2003 as this year's date <grin>.
    Will take me until about August (with any luck).

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Replacing Dates (Excel 97)

    <P ID="edit" class=small>(Edited by JohnBF on 02-Feb-04 18:29. Clarity.)</P>Don't use "*/" in the Find-&-Replace, just "2003 in Find and "2004" in Replace.
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Replacing Dates (Excel 97)

    Hi Marc,

    You could:
    1. Type 365 into an unused cell (or 366 for post Feb 28 if you want to allow for the leap year).
    2. Copy the 365/366
    3. Select the dates you want to update
    4. Choose Edit|PasteSpecial,Values,Add
    5. OK

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  5. #5
    Lounger
    Join Date
    Jun 2002
    Location
    RTP, NC, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Replacing Dates (Excel 97)

    Thanks guys...both good suggestions. And yes, I thought I'd get a "jump" on things by starting in February with using '04....now if I could just remember how old I am when someone asks (without having to stop and think about it)

Posting Permissions

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