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

enter image description here

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


migrated from stackoverflow.com 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.


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.

  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

Start the cell with a ' character.

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.