Formulas behaving badly  
Author Message
MattBarsotti





PostPosted: Sat Nov 15 16:22:26 CST 2003 Top

worksheet functions >> Formulas behaving badly

I copy a formula from one worksheet cell to another
worksheet cell and it works, I see the calulated value.
If I double click the new cell it brings up the formula.
But if I change nothing and click the CHECK mark in seems
to convert the formula to text and display the formula in
the cell rather than the calculated value.

I also notice that if I attempt to edit the formula it
does not highlight the argument values if they are in a
separate work sheet. I have EXCEL 2002 SP-1

Excel432  
 
 
Alan





PostPosted: Sat Nov 15 16:22:26 CST 2003 Top

worksheet functions >> Formulas behaving badly But if I change nothing and click the CHECK mark.....
Not sure what you mean by that, please explain?


> I copy a formula from one worksheet cell to another
> worksheet cell and it works, I see the calulated value.
> If I double click the new cell it brings up the formula.
> But if I change nothing and click the CHECK mark in seems
> to convert the formula to text and display the formula in
> the cell rather than the calculated value.
>
> I also notice that if I attempt to edit the formula it
> does not highlight the argument values if they are in a
> separate work sheet. I have EXCEL 2002 SP-1


 
 
Earl





PostPosted: Sun Nov 16 10:14:04 CST 2003 Top

worksheet functions >> Formulas behaving badly John,

I can't reproduce this problem Excel 2002. Post the formula, and perhaps
the contents of its precedents (the cells to which it refers).

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------



> I copy a formula from one worksheet cell to another
> worksheet cell and it works, I see the calulated value.
> If I double click the new cell it brings up the formula.
> But if I change nothing and click the CHECK mark in seems
> to convert the formula to text and display the formula in
> the cell rather than the calculated value.
>
> I also notice that if I attempt to edit the formula it
> does not highlight the argument values if they are in a
> separate work sheet. I have EXCEL 2002 SP-1