Thank you so very much. I was actually able to use the 'paste special'
function to resolve this particular task.
--
Barb


"Kevin B" wrote:

It sounds like you want to reference the cell that contains the .80 as an
absolute reference.

To prevent the divisor from changing when copied do the following:

Assuming that your values are in column A starting in row 1, the divisor is
in E1, and you want the results in column B, enter the following formula:

=A1/$E$1

Then copy the formula down column B.

Another option would be to enter your divisor in a blank cell, and then
copy that cell to the clipboard. After copying the divisor, select the cell
containing the values that you want to divide and click EDIT in the menu,
select PASTE SPECIAL, click the DIVIDE option button and click OK. The
original values selected are now replaced by the result of the division.

Hope this helps.
--
Kevin Backmann


"Barb" wrote:

It has been a long time since I did this and I cannot remember how...I have a
column of numbers that I want to divide by .80......I cannot replicate or
duplicate because it just copies the first cell. I think I remember from
long ago you 'bracket' or something to copy that one constanent to the next
field.


--
Barb