31

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

0

2 Answers 2

42

comment it using the single quote

e.g.

'-A10

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

3
  • 3
    Thanks! Is there any option to turn it off though so I don't have to keep using a single quote? Dec 22, 2010 at 20:13
  • 4
    Maybe you can set the cell formatting to text/string before entering text.
    – Martin
    Dec 22, 2010 at 20:21
  • Preceding it by a space seems to be the easiest solution for me. Thanks everyone.... Dec 22, 2010 at 20:46
4

Use the 'find and replace' tool in excel. Find '=' and replace with nothing, i.e. an empty space. Then click on 'replace all.

1

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .