| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copy formulas - strange things happens
I have a problem I have never seen before - I have a row of numbers that I
want to divide by 1000 - I do as I usually do +CELL/1000 - when I drag to copy the formula down to the next cells I get the same number in all cells - the reference looks OK - If I do it "manually" in all cells, it works .... Does anybody have a clou on this ? |
|
#2
|
|||
|
|||
|
Make sure your wb is not set to manual calculation. Check
under Tools Options Calculation tab. HTH Jason Atlanta, GA -----Original Message----- I have a problem I have never seen before - I have a row of numbers that I want to divide by 1000 - I do as I usually do +CELL/1000 - when I drag to copy the formula down to the next cells I get the same number in all cells - the reference looks OK - If I do it "manually" in all cells, it works .... Does anybody have a clou on this ? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i copy vertical formulas to horizonal and keep same cell r. | Excel Discussion (Misc queries) | |||
| 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) | |||
| Copy and pasting graphs to PowerPoint | Excel Discussion (Misc queries) | |||
| Why won't formulas obey vertical alignment commands? | Excel Discussion (Misc queries) | |||
Linear Mode
