find replace problem

  • Thread starter Thread starter wab
  • Start date Start date
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
 
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).
 
or set the cells format to Text

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Thanks, I tried setting the format to text. But it didn't work. I used
Andy's suggestion. wally667
 
Back
Top