Try prefixing with an apostrophe at the same as the replace or formatting
cells as text before you do the replace.
Regards,
Peter T
"brownti via OfficeKB.com" <u31540@uwe wrote in message
news:82d35e94ffe4a@uwe...
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