I have an excel worksheet with quite a few entries that have dates with the wrong year. How can I replace just the year? I tried using the find and replace but it then just replaces the whole cell with just the year. So if I had 1/1/2011 it would change it to just 2010.
EDIT: Never mind, I got it.
Bookmarks