copy formula in 2007

H

hanslip

When I drag the formula in a cell it appears correctly in every copied cell
but returns the numerical value in the original cell.
 
D

Daniel.C

hanslip said:
When I drag the formula in a cell it appears correctly in every copied
cell
but returns the numerical value in the original cell.
Click to expand...

Click on Office button, Excel options, Formulas, Calculation mode, and check
that "automatic is selected.
Daniel
 
Top