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 ?

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 ?


.