Formula for adding a percentage to each cell

Hi, I was wondering if anyone could help.
I am working on a tender and have been given lots of prices on an excel sheet...
Basically I want to add labour, materials on profit onto each figure that the supplier has given me..

What formula can I use to add 30% on to the figure in each cell?
Ive been playing around with different ones for ages and have not had any luck and dont want to revert to doing them by hand as there are hundreds....

Any help would be gratefully received... Danni

Write in some cell 1.3
Copy
select cells you want to multiply
paste/spetial -> Multiply

Or you can write in one cell i.e. A1 30%

Then instead of SUM(A5:C5) formula (for example) you can use =SUM(A5:C5)*(1+$A$1)

so I would put =SUM(C350*1.3)?

is there any way of adding it to a figure already in the cell without copying each individual figure?

im new to all this formula business and not getting anywhere fast... sorry :{

oohh right im with you.!! thank you very much for your help! i'll give that a try!

I dont think I am getting it right.
I am wanting to change the figure in each individual cell by adding 30%.
i'm not wanting to add each figure together, then at 30%.
I have attached a section of the document im working on just incase anyone has any ideas.
So the figures in red I am wanting to add 30% to that number..
I dont think I'm making sense now....

thank you so much you clever people!!
I have managed to follow your great advise and have success!! woohoo!!

Thank you guys!!

dannni x