Let's say you want to increase the vales in A1:A10 by 15%
In empty cell (we'll call it Z1) type 1.15
Copy Z1; select A1:A10 and use Edit | Paste Special specifying Multiply in
the popup dialog box.
Your numbers have been increased.
All that remains is housekeeping - delete Z1
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address
"Aaron" wrote in message
...
Hello,
Is there an easy way to select a range of cells and change the value of
each
cell by the same percentage without adding formula columns?
Thank you,
Aaron