Function display

M

mrivera

Hello,

I have a function in a cell that doesn't calculate the value. Instead, I see
the function definition.
How do I change this to display the calculated value?

-mr
 
G

Gord Dibben

Just the one cell?

Was pre-foramtted as text.

Change to General then F2 and ENTER


Gord Dibben MS Excel MVP
 
M

mrivera

You're right, it was formatted as text. However, after changing to General
and pressing F2 it didn't change.
 
D

Dave Peterson

Did you select the troublesome cell, format it as general, then hit F2, then
Enter--in that order?

I'd try it once more.
 
Top