applying a formula to manycells that already contain values

[louiseg]

Hi could someone help with this please? I want to apply a simple formula to a number of cells in an exisiting workbook that already contain values eg
my column contains the values
5200
1600
4376
in separate cells
I want to divide each value by 1.2 - without having to change every individual cell - can it be done?

[oeldere]

a1=5200

b1= a1/1.2

or with an cell reference

b1 =1.2

c1 = a1/c1

and drag the formula down.

[Glenn Kennedy]

If they're in column A, starting in A1; in B1 type =A1/1.2

Copy this down as far as you need by grabbing the black dot at the bottom right of the cell B1 (left click & hold) and drag it down.