Strange if(***) behaviour?
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
|