When I enter a formula it shows the formula not the result
 

When I enter a formula it shows the formula not the result
 

Sounds like the cell is formatted as TEXT.

Format the cell as General. Then, with the cell still selected hit function
key F2 then hit ENTER

--
Biff
Microsoft Excel MVP


"Dominic" wrote in message
...

When I enter a formula it shows the formula not the result
 

And if you see the formula in each cell, maybe you're looking at formulas:

Tools|Options|view tab|Uncheck formulas

ctrl-`
control-backquote (near the 1/! on my USA keyboard) is the shortcut key

Dominic wrote:

--

Dave Peterson