Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want input ++-- in cell excel but error

enter image description here

How to input the ++-- or ---- as shown above.


share|improve this question

migrated from Sep 14 '12 at 20:04

This question came from our site for professional and enthusiast programmers.

Just precede it with a quote character:


This forces Excel to treat it a text rather than numeric entry, and it's the numeric entry that causes the problem since it expectes a digit somewhere in there.

share|improve this answer

There are several ways to make excel treat your input as a text rather than a formula.

  • Change the cells format to text before entering: ++--
  • Enter a character that identifies your input as a text: '++--
  • Input a Formula that outputs a text to the cell: ="++--"

all three approaches work equally well.

share|improve this answer
  1. Select the cells you want the input to be placed
  2. Right click-->Format cells
  3. In the first tab (Number), select the Category to be Text
share|improve this answer
Thanks, i have done. – Nhu Nguyen Aug 7 '12 at 8:54

Start the cell with a ' character.

share|improve this answer

You must log in to answer this question.