format cell
 

I have this in a cell; "2 vs 3" (without quotes), I want
to find and replace it with "2 - 3" (without quotes).
When I do this it either turns it into a date or a string
of five numbers. I have formatted the cell to be "text"
or "general" yet it still converts to a date or a string
of numbers. I would appreciate any help, thank WAB

WAB,

Try replacing with '2 - 3.

Using the single quote at the beginning will force to maintain the text.
Don't worry, the sinqle quote will not show in the cell.

HTH,
Paul

"wab" wrote in message
...
I have this in a cell; "2 vs 3" (without quotes), I want
to find and replace it with "2 - 3" (without quotes).
When I do this it either turns it into a date or a string
of five numbers. I have formatted the cell to be "text"
or "general" yet it still converts to a date or a string
of numbers. I would appreciate any help, thank WAB