1. Type 1.04 in some empty cell.

2. Edit/Copy that cell

3. Select the cells containing the prices

4. Edit/Paste Special and select the Values and Multiply options.


On Wed, 12 Dec 2007 10:10:01 -0800, John wrote:

I should know this....but, how do I add 4% to a range of cells?
(I'm trying to update a price sheet by increasing the % on existing prices)