Stop Excel recognizing a dash

Question

How can I stop my text cells which start with a dash from turning into cells where Excel expects a formula?

bubu · Answer 1 · 2010-12-22 20:09:13Z

up vote 8 down vote accepted

comment it using the single quote

e.g.

'-A10

will display -A10 in excel instead of it being misinterpreted as formula.

answered Dec 22 '10 at 20:09

bubu
6,1812929

Thanks! Is there any option to turn it off though so I don't have to keep using a single quote? – Sean McRaghty Dec 22 '10 at 20:13

1

Maybe you can set the cell formatting to text/string before entering text. – Martin Dec 22 '10 at 20:21

Preceding it by a space seems to be the easiest solution for me. Thanks everyone.... – Sean McRaghty Dec 22 '10 at 20:46

feedback

1 Answer