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

User · Answer

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

User · Answer

Try this if the above solution aren t working  worked for me  Cut the whole contents in the worksheet using  Ctrl   A  followed by  Ctrl   X  and paste it to a new sheet  Your reference to formulas will remain intact when you cut paste

User · Answer

Check for spaces in your formula before the      example   A1  instean   A1

User · Answer

I had the same problem and solved with below   Range  A   Formula   Trim CStr  the formula

User · Answer

If all else fails  Ctrl-H  search and replace  with     in both boxes  in other words  search on   and replace it with the same      Seems to do the trick

User · Answer

If you are using VBA to enter formulas  it is possible to accidentally enter them incompletely   Sub AlmostAFormula       With Range  A1            Clear          NumberFormat                Value     B1 C1           NumberFormat    General      End With End Sub   A1 will appear to have a formula  but it is only text until you double-click the cell and touch Enter    Make sure you have no bugs like this in your code

User · Answer

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

User · Answer

I tried everything I could find but nothing worked  Then I highlighted the formula column and right-clicked and selected  clear contents   That worked  Now I see the results  not the formula

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

Examples related to excel