It generally works. My problem now revolves around there are times that I
have to do this where it is not feasable to reformat the cells as they are
intermingled with cells that I do not want to change the fromatting on. Any
bright ideas?

"Frank Kabel" wrote:

Hi
try formating these cells as 'Text' before replacing them.

--
Regards
Frank Kabel
Frankfurt, Germany


Jim Thomlinson wrote:
Here is my problem. I have the following text replicated hundreds of
times throughout my spreadsheet. 'Oct 2003 and 'Nov 2003 and other
similar text strings. I would like to do a find and replace on the
year 2003 to 2004. When I do this Excel changes the cell from text to
date. How do I keep Excel from doing this. Note that the cell must
remain as text and that I can not just reformat the cell as the
string is a dimension name in an external OLAP cube, that Excel
References...

Thanks in Advance
Jim