If the cell was formatted as Text when the formula was entered, simply
changing the format to "General" or "Number" is *not* good enough.
You must re-enter (register) the formula *after* the format revision.
Just clicking in the formula bar, and then hitting <Enter will do.

Since you say that this problem is not too prevelant in your WS, you could
click in a "bad" formula cell, and try this keyboard shortcut to change the
format and register the formula:
<Ctrl <Shift <~
Then
<F2
then
<Enter
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Bryan" wrote in message
...
Using Excel 2000. I use a lot of IF statements in a machinery database
for
desiganating options. Most of the time IF statements I create work
correctly, but occassionally I have the problem where the statement works
correctly and displays the correct information using the wizard, but the
cell
itself displays only the formula, as if an ' was in front of the equation.
I
have tried checking the cell formats (in this case I'm formatting the cell
as
text), but I can't pin down why it works correctly 99.9% of the time, and
other times it doesn't. Any ideas would be helpful.... Thanks, BL