MS Excel showing the formula in a cell instead of the resulting value

Question

The above image shows 3 cells containing the formula instead of the value; The first cell is under PHP Hourly Rate, the second is under Name and the third is the Invoice Sub Total. However, the values will show after I double click the cell then press enter. Why is this happening? I am using Excel VBA on Excel 2013.

Thanks.

Answer 1

Make sure that...

• There's an = sign before the formula
• There's no white space before the = sign
• There are no quotes around the formula (must be =A1, instead of "=A1")
• You're not in formula view (hit Ctrl + ` to switch between modes)
• The cell format is set to General instead of Text
• If simply changing the format doesn't work, hit F2, Enter
• Undoing actions (CTRL+Z) back until the value shows again and then simply redoing all those actions with CTRL-Y also worked for some users

Answer 2

If you are using Excel 2013 Than do the following File > Option > Advanced > Under Display options for this worksheet: uncheck the checkbox before Show formulas in cells instead of their calculated results This should resolve the issue.