View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Shirley Shirley is offline
external usenet poster
 
Posts: 31
Default Want to Increase Prices by Percent

Bill:
Thanks for suggestion and it makes sense.
However, I took the steps you recommend and when I select "Paste Special"
from th Edit menu the only options I get are either Unicode Text or Text. I
have seen the screen with the Operation Multiply etc before, but in this case
I don't get it.
Am I doing something wrong or have something turned off?
--
ShirleyF


"Bill Kuunders" wrote:

one way

1.. In an empty cell, enter the number that you want to multiply by.....
1.10
2.. Select that cell, and on the Edit menu, click Copy.
3.. Select the whole range of numbers that you want to multiply.
4.. On the Edit menu, click Paste Special.
5.. Under Operation, click Multiply.
6.. Click OK.
7.. Delete the content of the cell entered in the first step.
Greetings from New Zealand



"Shirley" wrote in message
...
New to this. Am using Office-Excel 2000. Have entered three columns of
prices
for company (List, Dealer, Distributor). Prices will increase next month.
How do I increase all rows (example C3-C50) by 10 percent?
Will need to do this for all three columns.
--
ShirleyF