How to add 100 using a formula to existing data

[portconthire]

I have a spreadsheet with exisiting data and wish to add 100 to each number on the sheet. For example the existing data maybe say 250, 300, 110 etc. So that an additon is made to each existing number on the spreadsheet using a formula so that after adding 100 numbers woul dbe 350,400,210 etc. Thank You.

 

[Smitty]

Welcome to the Board!

You can put 100 in an unused cell, copy it, and select the range to which you want it added, then goto Paste Special-->Add.

HTH,

 

[portconthire]

Thank You Smitty. As simple as that and here I was thinking I would need to create a special formula.