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

Question

The first cell under PHP Hourly Rate, the second under Name, and the third under the Invoice Sub Total are the only ones in the preceding image that have the formula instead of the value. However, if I double-click the cell and then press Enter, the data will appear. Why is this taking place? I'm using Excel 2013 with VBA.

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

I hope this helps you.