add same number to a column of numbers

[Guest]

How do i add .25 to a column of 15 different numbers at one time instead of
doing it separately.

 

[Barb Reinhardt]

Let's say you have the 15 different numbers in A1:A20
In B1 put =A1+.25
Copy that down to B20

 

[Niek Otten]

Or: enter .25 in an empty cell. Edit>Copy.Select A1:A20
Edit>Paste Special, check Add

--
Kind regards,

Niek Otten

| Let's say you have the 15 different numbers in A1:A20
| In B1 put =A1+.25
| Copy that down to B20
|
| | > How do i add .25 to a column of 15 different numbers at one time instead
| > of
| > doing it separately.
|
|

 

[Guest]

I want to add the .25 to the same column. i.e if i highlight A1 to A15 then
somehow add +.25 then all the numbers in the A column would increase by .25

 

[Pete_UK]

Niek has given you the way to do it.

Pete