View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default how do i increase the value of numbers in a column by a percentage

Say you want to add 10% to all prices, then enter 1,1 in an unused cell,
copy the cell, then select the price column, and goto Edit PasteSpecial
Operation: Multiply.

Regards,
Per

"colinchurcher" skrev i
meddelelsen ...
i have an excel stocklist with 6000 items on it ,i just need to know how
to
increase the whole price list column by a percentage , thanks