formulas

[cocacola]

my formulas are not calculating after i copy content from one worksheet to create another.

suggestions?

 

[Mark W.]

Set your Calculation mode to "Automatic". See the Tools | Options... menu command's Calculation tab.

If the formulas themselves are displayed rather than their resultant values reformat the cells to a number format other than Text.
This message was edited by Mark W. on 2002-10-21 12:13

 

[Andrew Poulsom]

If it says Calculate in the status bar, you need to press F9.

 

[cflorackis]

Hello,

make sure that you do paste special values from the one worksheet to the other (after copying, simply do right click and choose special value ).

Then follow mark's advice---------set automatic calculation (Tools etc.......)