Adding percentages to a series of cells

[Damian Sargent]

Help,

I'm trying to add 3% to a series of cells all with different values (256 ,1009, 568 etc....).

How do I do this without the formula just multiplying the value by 3%? I've tried putting in 3% to a blank cell then copying, paste speacial to selected cells, values and either add or multiply to no avail????

 

[VoG]

Try putting 1.03 in a blank cell, copy, edit > Paste special and multiply.

 

[njimack]

You should be able to stick 1.03 in a blank cell, and then use paste-special multiply. The only other alternative I can think of is a simple macro.

 

[mikerickson]

Put 1.03 in a cell, select that cell, copy , select the data, PasteSpecial-operation multiplication.

 

[Damian Sargent]

Fab - percentages were never my forte!