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

RD,
Sorry for the late reply, but I just got back in the office to face this
problem again, and your keyboard register worked!!! Can't tell you how much
I appreciate your answer, and how many hours you have saved me!! Thanks, BL


"RagDyer" wrote:

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

Thanks for the feed-back, no matter how belated.
--

Regards,

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

"Bryan" wrote in message
...
RD,
Sorry for the late reply, but I just got back in the office to face this
problem again, and your keyboard register worked!!! Can't tell you how much
I appreciate your answer, and how many hours you have saved me!! Thanks,
BL


"RagDyer" wrote:

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