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?

0

2 Answers

comment it using the single quote

e.g.

'-A10

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

3

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

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy