find replace problem

W

wab

Hi, the problem I'm having is; in a cell I have "2 vs 1"(ignore
quotes). When I use find 2 vs 1 and replace with 2 - 1 it returns
either a date or a five digit number. I have tried to format the cell
in the text mode but to no avail. Thanks in advance. wally667
 
G

Guest

Hi

This is because Excel is trying to be helpful, and it formats your 2-1 as a
date. Try putting in '2-1 instead (with a leading apostrophe).
 
B

Bob Phillips

or set the cells format to Text

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
W

wab

Thanks, I tried setting the format to text. But it didn't work. I used
Andy's suggestion. wally667
 
Top