Stop Excel recognizing a dash
How can I stop my text cells which start with a dash from turning into cells where Excel expects a formula?
Solution 1:
comment it using the single quote
e.g.
'-A10
will display -A10
in excel instead of it being misinterpreted as formula.
Solution 2:
Use the 'find and replace' tool in excel. Find '=' and replace with nothing, i.e. an empty space. Then click on 'replace all.