title: MS Excel showing the formula in a cell instead of the resulting value
body: <p><img src="https://i.stack.imgur.com/nQqiP.png" alt="excel sheet showing the 3 cells with formula instead of value"></p>
  
  <p>The above image shows 3 cells containing the formula instead of the value; The first cell is under <em>PHP Hourly Rate</em>, the second is under <em>Name</em> and the third is the <em>Invoice Sub Total</em>. 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.</p>
  
  <p>Thanks.</p>