FYI the display Option under advanced is set to display the value vs. the
formula and set to auto-calculate.

"Candyman" wrote:

I have 2007. While scrolling down Excel went into recovery mode. Now my
functions will not show the value in the cell. in Formula wizard the
resultant value is correct, but stil does not transfer to the cell value. I
see the formula only. I tried going to teh Formula toolbar and clicking 'show
Formulas' the cell toggles to show more formula or less.

HELP!
TIA