MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Find and replace date


Posted by Pat on February 10, 2002 9:23 PM

I have a column of dates (2/6/02) that I want to "find and replace with 2/13/02. I highlight the column (only 15 rows of a much longer column), go to edit, select find and put in whats already in that column (2/6/02) and what I want the old date replaced with (2/14/02). It gives a message saying no cells contain data. I'm looking at the data, its highlighted but cannot find it. What's going on with that?????????


Posted by Richard S on February 10, 2002 10:11 PM

In the formula bar, what appears. You probably need to use for digit year format, ie 02/6/2002 and 02/13/2002.
HTH
Richard