need Excel cell to show value, not formula

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

Biff

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why does forumula show in cell instead of formula result? 2
formula displays as a formula, not as its result 1
Function argument not returning a value 11
Cell reference in formula string displays abbreviated value 2
Concatenating two text strings, formula is right, cell output is w 3
how to find #ref! invalid cell references within cell formula 6
Formula result not appearing in Cell 1
Formula Result is "V6", need Excel to use cell "V6", not the resul 3

Top