percentage
 

i have a col. as a price sheet and i want to take the whole row and reduce
the prices by 36% how do i do it

percentage
 

This is one way to do it

Put 0.64 in an empty cell
Copy that cell
Select column of prices
Edit Paste Special Multiply OK


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521941

percentage
 

In some empty cell, enter 0.64 and copy it (ctrl+c).
Highlight your prices and Edit Paste Special, select Multiply and click OK.
--Bruce

"mowerman" wrote:

i have a col. as a price sheet and i want to take the whole row and reduce
the prices by 36% how do i do it