Excel displays formula instead of value

In this article we are going to see one of the possible scenario where Excel 2016 & 2013 displays formula instead of value. Let us take the following sample data where cell C4 is showing test instead of calculated value.


Navigate to Cell C3 and check the Format specified for the Cell.


Now change the Format from Text to General by clicking the Format drop down under Number section and select General from the list.


After changing the format press F2 on the Keyboard followed by Enter key. This should reflect the change in Cell format and will display result of the Formula.


Note :- This is not specific to Excel 2013, you will notice this problem even in previous versions of Excel.

In Category: Excel 2013, Excel 2016, MS Office

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.