Thread: how do i increase the value of numbers in a column by a percentage
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default how do i increase the value of numbers in a column by a percentage
Say we want to increase a column of values by 6%. In an unused cell, enter
1.06. Copy this cell. Select the column of numbers. PasteSpecial Multiply
--
Gary''s Student - gsnu200909


"colinchurcher" wrote:

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
Reply With QuoteReply With Quote