| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying formulas
I have experienced a problem new to me. A have a row of
figures that I want to divide with 1000. I do as I usually do +CELL/1000 in a new row. When I want to drag the formula down to the rest of the row, I get the same number in all cells, but the reference looks OK. If I do it "manually" in all cells it works ... Does anybody know what could be wrong ? |
|
#2
|
|||
|
|||
|
Peter
ToolsOptionsCalculation. Checkmark "Automatic". Gord Dibben Excel MVP On Mon, 17 Jan 2005 07:39:42 -0800, "Peter Kristensen" wrote: I have experienced a problem new to me. A have a row of figures that I want to divide with 1000. I do as I usually do +CELL/1000 in a new row. When I want to drag the formula down to the rest of the row, I get the same number in all cells, but the reference looks OK. If I do it "manually" in all cells it works ... Does anybody know what could be wrong ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| copying formulas | Excel Discussion (Misc queries) | |||
| Errors in copying formulas | Excel Discussion (Misc queries) | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
Linear Mode
