How to add one number to a range of numbers

[BatonRougeguy]

If i have a range of numbers in one column, how do i go about adding a single
number to this entire range? for example if i have
345
654
143
7553
45465
how do i add .009 to each of these numbers in the range?

 

[Oliver Ferns via OfficeKB.com]

Hi,
This is easy. Put 0.009 into a blank cell and copy it. Now select the range
that contains the values you want to add this value to, goto Edit-

PasteSpecial->Add (alt+E, S, Alt+D), and voila!

Hth,
Oli