by acknak » Wed Dec 12, 2007 6:55 pm
Hagar's suggestion is good, and easy, but if the original values are your raw data, you may wish to preserve them, so in the future you can go back and see exactly what was done, and back it out or otherwise change the analysis.
If that is the case, you can do the addition by changing the current values to a formula:
Select the cells to change
Edit > Find & Replace
Search for: .*
Replace with: =&+20
Options / Regular expressions: YES
Options / Current selection only: YES
Replace all
This changes a value, like "123.45" to a formula: =123.45+20, so the original data are still there, if you ever need to know.
Even better, if you can, just use a separate column for the calculation.
AOO4/LO5 • Linux • Fedora 23