copy formula in 2007

  • Thread starter Thread starter hanslip
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting based on formula cell 6
Formula won't copy down the column 1
Copy formula 6
Problem with numbers not displayed correctly 3
SUM / COUNT formula 3
Excel 2007 average formula 3
Count Values in a Range, Not Formulas 2
Attempting to copy a formula by scrolling 1

Back
Top