Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMAT PERCENTAGE IN INDEX CELL? | New Users to Excel | |||
Percentage Calculation | Excel Worksheet Functions | |||
Formatting percentage signs in Excel | Excel Discussion (Misc queries) | |||
percentage of production against quotation | Excel Discussion (Misc queries) | |||
percentage of sales | Excel Worksheet Functions |