Help!

L

lola

Hi

I know this is probably really simple but i can't figure
it out! I have a column of prices, and i need to take away
35% from each of them but can't work out how i do this
have tried highlighting all the ones that i need to take
the percentage away from but can't find out how to take
this away.

any help would be really appreciated.

xx
 
A

Arvi Laanemets

Hi

Enter 0.65 into any empty cell and copy it
Select the range with data to convert, and then PasteSpecial.Multiply - OK
 
A

anon

The macro below multiplies the current value by 0.65 and
then moves down to the next lower cell. (You could assign
a keyboard shortcut to it if you need to do it
repetitively.)

Sub Macro1()
ActiveCell.Value = ActiveCell.Value * 0.65
ActiveCell.Offset(1).Activate
End Sub
 
Top