Ok, this is my problem, I need to add the value of 20.. to a TON of cells in this excel document, and i really don't want to do each and every cell manually.. I'm wondering if there's any possible way to add the values automatically for each cell that has a number.
Here's a screen shot of it.
Basicly, those first numbers circled. on the top-left,
420
320
ect..
It may be easier to copy the data to a 2nd worksheet. For example, if you have your numbers in column A on Sheet1, then you'd create a 2nd sheet and type the following in column A....
=Sheet1!A1+20
Then you could click on the bottom right corner of the cell and drag it down to fill in the rest of the column with the same formula (=Sheet1!A2+20, =Sheet1!A3+20, =Sheet1!A4+20, etc...).
