Find and Replace - Auto Cell Formats

[bslater]

I have a column of date data that is in text format by design. I want
to do a find and replace for this column to change "/2003" to "/03",
"/2004" to "/04", etc. I have coded this into my macro, but Excel
automatically sets the cell format to a date type when the find and
replace occurs. Is there any way to stop this from happening? Can I
lock the format of these cells?

Thanks!

 

[John Green]

If you place a single quote in front of each cell entry ('), it will be treated as text and the replace will leave the entry as
text.