Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing values by a %
Hi,
I have a worksheet with thousands of prices that need amending by a certain percentage. Is there a way of amending all cells in such a way, without creating seperate fields for the answers ? So basically it may read as £10 and I need to knock off 40% to change it to £6, but the sheets are pricelists that are all in a pretty layout that I dont want to change. Thanks Jon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing values by a %
In a blank cell somewhere you should enter 0.6 (if you want to reduce
by 40%). Select that cell again and click on <copy. Then you should select the cells that you want to change and click on Edit | Paste Special | Values (check) | Multiply (check) | OK then <Esc. Hope this helps. Pete On Jan 21, 2:15*pm, "jon" wrote: Hi, I have a worksheet with thousands of prices that need amending by a certain percentage. Is there a way of amending all cells in such a way, without creating seperate fields for the answers ? So basically it may read as £10 and I need to knock off 40% to change it to £6, but the sheets are pricelists that are all in a pretty layout that I dont want to change. Thanks Jon |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing values by a %
Hi Jon
In an unused cell enter .6 (1-40%) and copy the cell. Select the price cells and goto Paste Special Operation: Multiply OK Hopes it helps --- Per "jon" skrev i meddelelsen ... Hi, I have a worksheet with thousands of prices that need amending by a certain percentage. Is there a way of amending all cells in such a way, without creating seperate fields for the answers ? So basically it may read as £10 and I need to knock off 40% to change it to £6, but the sheets are pricelists that are all in a pretty layout that I dont want to change. Thanks Jon |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing values by a %
Fantastic,
Thank you "Pete_UK" wrote in message ... In a blank cell somewhere you should enter 0.6 (if you want to reduce by 40%). Select that cell again and click on <copy. Then you should select the cells that you want to change and click on Edit | Paste Special | Values (check) | Multiply (check) | OK then <Esc. Hope this helps. Pete On Jan 21, 2:15 pm, "jon" wrote: Hi, I have a worksheet with thousands of prices that need amending by a certain percentage. Is there a way of amending all cells in such a way, without creating seperate fields for the answers ? So basically it may read as £10 and I need to knock off 40% to change it to £6, but the sheets are pricelists that are all in a pretty layout that I dont want to change. Thanks Jon |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing values by a %
You're welcome, Jon - thanks for feeding back.
Pete On Jan 21, 2:30*pm, "jon" wrote: Fantastic, Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing values | Excel Discussion (Misc queries) | |||
Axis Values Keep changing | New Users to Excel | |||
If Then statement for changing Values | Excel Worksheet Functions | |||
Macro is changing values!!! | Excel Discussion (Misc queries) | |||
Bar graph values keep changing | Charts and Charting in Excel |