format cell

  • Thread starter Thread starter wab
  • Start date Start date
W

wab

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 5
This cell contains a date string rep. with only 2 digits for the y 5
Convert Date string to date format 7
formatting cells fractions - HELP 7
Formatting Text to Numbers for Dates 1
Excel Macro to automatically go to the right of the last colored cell 0
Cell Format 1
Convert date to text without changing format dd/mm/yy 3

Back
Top