Any chance you have a "helpful" macro butting in?

I'd open excel in safe mode
windows start button|Run
excel /safe

file|open your workbook
test it out.

If the formula doesn't get converted to values, then I'd look for macros that
are doing this.

Excel 2003 - SPB wrote:

I have typed the following in
n20 =if(o20=1,"yes","No")
when I type 1 into o20
n20 becomes Yes
the formula disappears it is not the only cell to have this problem
any suggestions?

--

Dave Peterson