need Excel cell to show value, not formula

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

Guest

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?
 
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
 
Thanks. This fixed the problem.

Biff said:
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
Click to expand...
 
Back
Top