You don't type in a formula for each of 2500 cells. You type in 1 formula
and copy it to 2500 cells. It takes about 2 seconds!

For example, if the range for the formulas is F2:F2500, type the formula in
F2.

Select cell F2 and goto the menu EditCopy.
Hit function key F5
Enter F3:F2500
Hit OK
Goto the menu EditPaste

Or, you can just "grab" the fill handle with the mouse and drag copy the
formula down the column. This might take 20 seconds. The fill handle is the
little black square in the lower right corner of the selected cell. When you
hover the mouse over the fill handle it will change from a "fat" + to a
"skinny" + . Then just "grab" it with the right mouse button and drag.

Biff

"Smokeyhavoc" wrote in message
...
doing it the way your saying would require me to do it in each cell, for
almost 2500 entries. I was looking for a formula to do each one
indivually,
but the whole colum in one fel swoop. Reason being is I need to do this
several times with other factors with the same base data

"Biff" wrote:

Assume your numbers in column D start in D2. Enter this formula in F2 and
copy down as needed:

=D2*1.05

Biff

"Smokeyhavoc" wrote in message
...
I have a colum of data almost 2500 entries long, what I want Excel to do
is
take each cell and multiply it by a given value and then display it in
a
corresponding cell
for instance:
colum d
BV
197
99
213
2465
886
1478
156
take each value and multiply it by 1.05 for:
colum f
ADJ BV
206.85
103.95 and so on down the colum

ANY help on this would be greatly appreciated as it would more than
likely
save me several hours worth of tedious work