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?
|