How do I simply add 2 to every cell in a range? so silly...

[Synthia]

I am trying to add 2 to every number (value) in every cell in a column (B117 to B500) and can't think clearly enough to get around circular...etc., I know it is simple Excel 101 but would appreciate the help anyway...(-:
Syndy

I tried <=Sum((B117:B500)+(2))

Thanks for indulging me...(-:

 

[VoG]

Type 2 into a spare cell and copy it.

Select B117 to B500, Edit > Paste Special, tick Add and click OK.

 

[T. Valko]

I am trying to add 2 to every number (value) in every cell in a column (B117 to B500) and can't think clearly enough to get around circular...etc., I know it is simple Excel 101 but would appreciate the help anyway...(-:
Syndy

I tried <=Sum((B117:B500)+(2))

Thanks for indulging me...(-:

See this...

http://contextures.com/xlDataEntry04.html

 

[Synthia]

THANK YOU so much, (-:
Synthia

Type 2 into a spare cell and copy it.

Select B117 to B500, Edit > Paste Special, tick Add and click OK.