Format the cell to General then F2 and ENTER

The cell was most likely pre-formatted as text.

Or if this is the only formula on the sheet you may have View Formulas checked.
Hit CTRL + `(backquote above Tab key) to toggle view formulas on/off.


Gord Dibben MS Excel MVP

On Thu, 4 Jan 2007 20:49:51 +0000, erajim
wrote:


I seem to be having trouble with my functions. I type in the function
and it isn't showing the result - just the formula.

For example I tried to concatenate: =CONCATENATE(A3,B3,C3,D3)

This was created using the wizard. So I'm pretty sure it is correct.

However the only thing showing in the cell is the formula. What
setting do I have wrong?

Thanks
Jim