Suppose your data is in the range A1:A10 and column B is empty

select cell B1 and type:
"=A1/8" (without speech marks)

Press enter - the value in A1 has been divided.

Select the cell again. Look at the thick black line around the cell which
indicates it is selected, and you will see that the bottom-right corner has
a "fill handle"

Drag the fill handle down to B20 (or the bottom of your data).





"yb" wrote in message
oups.com...
hi,

i have very little excel experience, i have a spreadsheet with a few
large columns (of numbers)

I need to divide each cells amount by 8. Is there a way to reference
the cell itself and divide the original value by 8? Alternatively, but
less useful would be if I can just do a divide by 8 on each value and
lose the original value. There are too many cells to do each one
individually

I tried circular reference with iteration count of 1 but that didn't
work. Thanks in advance.