View Single Post
  #4   Report Post  
BayComp
 
Posts: n/a
Default

Neik , fredrik , a million thanks guys :), works perfect



"Niek Otten" wrote:

In an empty cell, enter =1+YourPercentage, (like =1+4%)
EditCopy
Select your data
EditPaste Special, Check Multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"BayComp" wrote in message
...
How di i change the value of all data in a column by a given percentage?
e.g
i want to increase an entire columns entered values by a percentage i
choose.


TIA