H hanslip Sep 5, 2008 #1 When I drag the formula in a cell it appears correctly in every copied cell but returns the numerical value in the original cell.
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 Sep 5, 2008 #2 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
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
