There are a couple reasons why this may be happening.

Make sure "Display Formulas" is turned off. From the TOOLS Menu, select
OPTIONS. On the VIEW Tab, uncheck the box under Window Options labeled
"Formulas".

If that doesn't fix it, then your cell was most likely preformatted as Text.
Select the cell. From the FORMAT Menu, select CELLS. On the NUMBER Tab,
change the Category to "General". Click OK. Re-enter your formula (press F2
then Enter).

HTH,
Elkar


"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




--
erajim