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!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/