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.