Does this happen to all formulas or just one? The cell is likely
formatted as Text. Change the format to General and then select
the cell. Press F2 then Enter.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"carpfish" wrote in message
...
Instead of the result of a formula showing up in the cell, the
formula itself
is displayed.