One way ..

Assuming data starts in M2 down

Enter the constant into N1: 100 (say)

Put in N2: =IF(ISERROR(M2/$N$1),"",M2/$N$1)
Copy N2 down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"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!