Tuesday, 2 July 2019

How to force excel to stop thinking your cell contains a formula


I'm trying to enter, "-0.0028 (204)" into a cell in excel, but it keeps attempting to evaluate this (non-)expression as, "=-0.0028*(204)". This occurs even when I set the cell format to, "General". Any suggestions? Thank you!



Answer



Use the single quote ' before whatever you're entering.


No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...