Hi Bryan, every once in a while i get that as well, unfortunately i have no
work around other than to delete the cell and try again. I train Excel in my
company and one of my training sheets has a similar problem, if i move it
away to another cell it'll start working again. Not too much help sorry :)

HTH,

Kevin M

"Bryan" wrote:

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