Function display
 

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

Function display
 

Just the one cell?

Was pre-foramtted as text.

Change to General then F2 and ENTER


Gord Dibben MS Excel MVP

On Thu, 7 Jun 2007 10:42:01 -0700, mrivera
wrote:

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

Function display
 

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

"Gord Dibben" wrote:

Just the one cell?

Was pre-foramtted as text.

Change to General then F2 and ENTER


Gord Dibben MS Excel MVP

On Thu, 7 Jun 2007 10:42:01 -0700, mrivera
wrote:

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

Function display
 

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

I'd try it once more.

mrivera wrote:

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

"Gord Dibben" wrote:

Just the one cell?

Was pre-foramtted as text.

Change to General then F2 and ENTER


Gord Dibben MS Excel MVP

On Thu, 7 Jun 2007 10:42:01 -0700, mrivera
wrote:

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



--

Dave Peterson

Function display
 

Did you press ENTER after F2?


Gord

On Thu, 7 Jun 2007 16:53:00 -0700, mrivera
wrote:

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

"Gord Dibben" wrote:

Just the one cell?

Was pre-foramtted as text.

Change to General then F2 and ENTER


Gord Dibben MS Excel MVP

On Thu, 7 Jun 2007 10:42:01 -0700, mrivera
wrote:

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