MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Change Year

Posted by Scott on July 05, 2001 2:31 PM

I've got about 1000 rows of data with the date as one of my column fields. I entered the date using the 4/27 format.....without entering the year (They all defaulted to 2001 without me knowing it)....Now, I need to go back and change some of the dates to 4/27/89, 4/27/91....Is there a quick way of doing this so I don't have to go back and retype all of these dates back in? Thanks, Scott

Posted by IML on July 05, 2001 2:35 PM

If you entered them in chronological order, you could use Find and Replace for each year. For instance highlight your 200 dates in a row from 1987, type in 2001 in find and 1997 in replace and replace all. If they aren't in order ... yikes.

Posted by Scott on July 05, 2001 3:26 PM

Hey thanks a million!!!! I'm already done, it only took about 5 minutes....Greatly appreciated......THANK GOD they were in chronological order....Lots of thanks, Scott