Formula is Displayed Instead of Calculating a Value in Microsoft Excel


When you type your formula into a cell, and you see the formula instead of a value, it means one of two things:

  • You are viewing formulas. Just hit Ctrl+` (that's the accent mark near your Esc key on your keyboard).
  • Your cells are formatted as text. Just hit Edit Clear All.