software

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


This is one way to do it

Put 0.64 in an empty cell
Copy that cell
Select column of prices
Edit gt; Paste Special gt; Multiply gt; OK--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=521941In some empty cell, enter 0.64 and copy it (ctrl c).
Highlight your prices and Edit gt; Paste Special, select Multiply and click OK.
--Bruce

quot;mowermanquot; wrote:

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