I would think that if you enclose the replace with in quote marks(i.e. "3/0")
it should take it as text and not convert to a date.

"brownti via OfficeKB.com" wrote:

I have a bunch of cells that have measurments in them formatted like this 3'-
0". I would like to change these to 3/0 but when i do a find and replace
(even after setting the format to text for these cells) it turns them into a
date. is there a way to do a find and replace but leave the format as text?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200804/1