In an empty cell enter -say - 1.03 and copy the cell, ( to increase the data
by 3%

Highlight the data you want to increase and then right-click and select
Paste Special Multiply

All highlighted cells will be increased by 3%

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"jonilyn" wrote in message
...
What's the best way to increase a whole series of numbers by the same
percentage? Usually all in one column. Thank you.