No Macros
Checked against/via alt&F11
I am running some forms which load results of 1 or 0 to the "o" cells
I have no Data "ControlSource" with cell referances

another thing when I copy a formular into the "effected cell" it instantly
changes to Text?


"Dave Peterson" wrote:

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