Excel formula showing up as text not value??

In Excel

All of a sudden when I enter a formula that refers to another cell in Excel 2012 (for example =A23) the result does not show up but rather the actual formula shows up.  What has happened?

Thanks
 

Question Info


Last updated August 15, 2019 Views 148,994 Applies to:
Answer
Answer
If a cell is formatted as text when you enter a formula, and if you then change the format to (for example) General, you'll still see the formula. You have to press F2 then Enter, or enter the formula anew, to see the result.
---
Kind regards, HansV
www.eileenslounge.com

208 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.