Symbols inside cells

G

Guest

I want to put a symbol in a cell with a number, [+2] for example. However
when I do this Excel automatically removes it, [+2] becomes [2]. How can I
get Excel to leave the cell, or others like it, alone?
 
G

Govind

Hi,

Type a single quote first and then type what you need.

For eg. type ='+2 which would appear as +2

Regards

Govind.
 

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
how to strip an individual symbol from each row in a column 1
Excel Count If Formula Question 1
Automatic Symbol Insertion In Cell 1
Auto date in excell 2010 4
Symbol fonts 2
Automatically inserting a symbol when text is entered in the cell 1
Automatically input a symbol in a selected cell 2

Top