Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

enter image description here

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

Thanks

share|improve this question

migrated from stackoverflow.com Sep 14 '12 at 20:04

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

4 Answers 4

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.