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
--
Regards,
Peo Sjoblom
"hwalders" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>
|