Find and Replace with Formatting
 

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

Find and Replace with Formatting
 

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

Find and Replace with Formatting
 

Nope. It then replaces it with "3/0". Any other thoughts?

JLGWhiz wrote:
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.

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

Find and Replace with Formatting
 

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