changing numbers in a column by a percentage

  • Thread starter Thread starter hwalders
  • Start date Start date
H

hwalders

I have a column of product prices and want to increase all prices in that
column by 10%. I'm new at this and sure could use some help.

Thanks
 
put 1.1 in an empty cell
Edit|copy that cell
Select the range to adjust
edit|Paste special|check multiply
clear that cell with 1.1 in it.
 
I would personally use a help column, format it as currency then a formula
like

=A2*1.1


then copy down as long as needed, finally copy the new column and paste
specials as values in place

Another alternative

put 1.1 in an empty cell, format it as currency, copy it and select the
column with prices and do edit>paste special and select multiply
 
Back
Top