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

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?
 
N

Niek Otten

Format the cell as text before entering the symbol, or precede the symbol
with an apostrophe (which will not show in the cell).
 

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

Getting ### (hash) symbols in text cell instead of text 2
# symbol appearing instead of typed text in a cell 1
Text shows up at all # symbols 3
Viewing Control Characters 3
Using + and / as characters not as functional formatting 9
Excel Not Re-Drawing Symbols Consistently 3
Use CountIf() with symbols 3
vba macro that allows insertion of symbols at cursor 0

Top