Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
How can I stop my text cells which start with a dash from turning into cells where Excel expects a formula?
comment it using the single quote
will display -A10 in excel instead of it being misinterpreted as formula.
Use the 'find and replace' tool in excel. Find '=' and replace with nothing, i.e. an empty space. Then click on 'replace all.