excel problem

[t0psales]

I have a collum that is my buy price, I want to ad say 10% to that, I have over 1200 items I need to do it to, I understand that I can "paste special" but what is the formula.

I were thinking but the dont seem to work

=a1+10%

 and somehow get the same formula for all of the rows

or =a1*110%

Any ideas?

[xmystical_memoriesx]

+a1*110%

$10 x 110% = $11.00

[t0psales]

not working, but basic idea of what I want to do

[marshbunyip]

+a1 * 1.1

[clarry100]

If your starting value (say 10) is in cell A1

And the result you want is to be in B1 then just copy this text including the "=" sign into B1

=A1*110%

The value you the see in B1 will be 11, but the formula in there will be the text above.

Then when you just copy this formula down it will automatically self-adjust to become

=A1*110%

=A2*110%

=A3*110%

.

.

.

etc

[my_wishes_and_dreams]

Click on B1

Then  =A1*1.1

If A1 is 10 then B1 will be 11

Then just drag the B1 formula down to the end of your listings 

[my_wishes_and_dreams]

ooops  mouse over B! until you get the +, should be in the bottom right hand corner .Right click and then drag the formula down over the required number of cells. Excell will automatically put the formule in the "B" column cells