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...
How can I stop my text cells which start with a dash from turning into cells where Excel expects a formula?
2 Answers
comment it using the single quote
e.g.
'-A10
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.
Marcus Vance is a cybersecurity auditor and technology writer dedicated to educating the public about online safety, data privacy regulations, enterprise security, and emerging cyber threats.
