Find and Replace with Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brownti - 17 Apr 2008 19:48 GMT

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?

Reply to this Message

JLGWhiz - 17 Apr 2008 20:37 GMT

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?

Reply to this Message

brownti - 17 Apr 2008 21:40 GMT

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

>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.
[quoted text clipped - 3 lines]
>> (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?

Reply to this Message

Peter T - 17 Apr 2008 22:10 GMT

Try prefixing with an apostrophe at the same as the replace or formatting
cells as text before you do the replace.

Regards,
Peter T

Reply to this Message