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.