I want input
++-- in cell excel but error
How to input the
---- as shown above.
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.
all three approaches work equally well.
Start the cell with a ' character.