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

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

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

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

Changing values by a %
 

You're welcome, Jon - thanks for feeding back.

Pete

On Jan 21, 2:30*pm, "jon" wrote:
Fantastic,

Thank you