View Single Post
  #4  
Old October 9th, 2006, 07:09 PM posted to microsoft.public.excel.worksheet.functions
Biff
external usenet poster
 
Posts: 1,559
Default 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?