need Excel cell to show value, not formula
 

I have Excel 2003. I've entered concatenation formula, which is calculating
correctly, but the cell itself shows the formula, instead of the result. The
formula bar also shows the formula, which I expect. The only way I can see
the result is to open up the Function Argument window (click on fX in formula
bar).

Can anyone help me get the result to display in the cell itself? I've tried
simple replacement formulas (e.g., =D2), but still get same thing. Is there a
setting somewhere I'm missing?

need Excel cell to show value, not formula
 

The cell is probably formatted as TEXT. Set the format to GENERAL then, with
that cell still selected hit function key F2 then hit ENTER.

Biff

"jori" wrote in message
...
I have Excel 2003. I've entered concatenation formula, which is calculating
correctly, but the cell itself shows the formula, instead of the result.
The
formula bar also shows the formula, which I expect. The only way I can see
the result is to open up the Function Argument window (click on fX in
formula
bar).

Can anyone help me get the result to display in the cell itself? I've
tried
simple replacement formulas (e.g., =D2), but still get same thing. Is
there a
setting somewhere I'm missing?

need Excel cell to show value, not formula
 

Thanks. This fixed the problem.

"Biff" wrote:

The cell is probably formatted as TEXT. Set the format to GENERAL then, with
that cell still selected hit function key F2 then hit ENTER.

Biff

"jori" wrote in message
...
I have Excel 2003. I've entered concatenation formula, which is calculating
correctly, but the cell itself shows the formula, instead of the result.
The
formula bar also shows the formula, which I expect. The only way I can see
the result is to open up the Function Argument window (click on fX in
formula
bar).

Can anyone help me get the result to display in the cell itself? I've
tried
simple replacement formulas (e.g., =D2), but still get same thing. Is
there a
setting somewhere I'm missing?

need Excel cell to show value, not formula
 

You're welcome. Thanks for the feedback!

Biff

"jori" wrote in message
...
Thanks. This fixed the problem.

"Biff" wrote:

The cell is probably formatted as TEXT. Set the format to GENERAL then,
with
that cell still selected hit function key F2 then hit ENTER.

Biff

"jori" wrote in message
...
I have Excel 2003. I've entered concatenation formula, which is
calculating
correctly, but the cell itself shows the formula, instead of the
result.
The
formula bar also shows the formula, which I expect. The only way I can
see
the result is to open up the Function Argument window (click on fX in
formula
bar).

Can anyone help me get the result to display in the cell itself? I've
tried
simple replacement formulas (e.g., =D2), but still get same thing. Is
there a
setting somewhere I'm missing?

need Excel cell to show value, not formula
 

Thanks, Biff! This has been dirving me crazy for quite a while.
Jim

"Biff" wrote:

The cell is probably formatted as TEXT. Set the format to GENERAL then, with
that cell still selected hit function key F2 then hit ENTER.

Biff

"jori" wrote in message
...
I have Excel 2003. I've entered concatenation formula, which is calculating
correctly, but the cell itself shows the formula, instead of the result.
The
formula bar also shows the formula, which I expect. The only way I can see
the result is to open up the Function Argument window (click on fX in
formula
bar).

Can anyone help me get the result to display in the cell itself? I've
tried
simple replacement formulas (e.g., =D2), but still get same thing. Is
there a
setting somewhere I'm missing?