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