Hi

you can use another cell somewhere, e.g. P1 and then the formula in N1 would
be
=M2/$P$1
you can then fill this down (move your mouse over the bottom right hand
corner of M2 until you see a + then double click or drag down the column)

if you don't want to use a cell to do this in you can use a range name,
choose insert / name / define - type a name (e.g. c_factor) and then in the
refers to box type the value (eg. =10) click ADD then OK
now in the first cell type
=M2/c_factor
and fill down

Cheers
JulieD


"Wild Bill" wrote in message
89.191...
I rarely use Excel, but I need help with this one problem.
I'm data logging some parameters on my race car and I need to apply a
constant to an entire column of data to get a correction factor.
Example:
Column M has 2700 lines of data. I need to divide each cell by a constant
and have that show in each cell of column N.
Please help me!