View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default calculating percentage

Hi,

Put 1.05 in a cell somewhere and select the cell and copy it.

Select the numbers to multiplt and then

Edit|paste special - select multiply and Ok

Delete the cell wih 1.05 in

Mike

"Dabbles" wrote:

Okay, so I figured out how to increase one number by a percentage but i want
to increase all the numbers in a column by 5%. I was told that there is a way
to change the whole column instead of increasing them one by one. Can
someone help me?