Function display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Just the one cell?

Was pre-foramtted as text.

Change to General then F2 and ENTER


Gord Dibben MS Excel MVP
 
You're right, it was formatted as text. However, after changing to General
and pressing F2 it didn't change.
 
Did you select the troublesome cell, format it as general, then hit F2, then
Enter--in that order?

I'd try it once more.
 
Back
Top