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.