Thank you! Thank you! Thank you! it worked! I love this site... now maybe I
can get this done :)

"pinmaster" wrote:

Your cell may be formatted as "text", format as "general" or "number" then
hit F2 and Enter.

HTH
JG

"ewan7279" wrote:

This may seem obvious, but is there an " = " sign in the cell before your
formula...?

"CMIConnie" wrote:

Help! I have a conditional formula that will not show the result. It shows
only the formula. Right now, the formulas box in the view tab under
tools/options is UNCHECKED and the formula still shows. I've tried checking
the box and it still shows. I really need my result in the cell and the day
is getting away from me...(Excel 2000)