Entering symbols +, -, = as text instead of as functions

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

I need to be able to enter the symbols + - = as text in a column to
indicate gain, loss, and neutral. How do I ensure they are treated as text
and not functions?
 
Format the cell as text before entering the symbol, or precede the symbol
with an apostrophe (which will not show in the cell).
 
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

Greater Than Symbols and calculations 0
The @ symbol 7
Excel Count If Formula Question 1
Getting ### (hash) symbols in text cell instead of text 2
# symbol appearing instead of typed text in a cell 1
Remove # Symbol 2
Can no longer instert symbol in text box 1
Decimal symbol not converting 3

Back
Top