It sounds like your cell may be formatted as text.
Remove the formula, from the Format Menu Select CellsNumberGeneral.
Then retype the formula.

Hope this helps
Rowan

Stupid Word User wrote:
That is what I have in the formula. I just used parentheses here. The
formula is exactly as you show it.

"JRod" wrote:


The right formula is: =SEARCH(" ",E2)

--
JRod
Microsoft MVP - Excel
http://EXCELer.blogspot.com

"Stupid Word User" escreveu na
mensagem ...

I have a very simple search function (=SEARCH(" ",E2)) in my formula and
when
i hit enter it only displays the formula, not the result. The formula is
right and in the preview it shows the correct value. Why will it not
display
this value?