formula question

  • Thread starter Thread starter zerconian
  • Start date Start date
Z

zerconian

How do you change a column of numbers all by a given percentage
ie all numbers in column B to individually have a value of -30
 
zerc

To remove 30% from all numbers in a column enter .7(point seven) in an empty
cell of another column.

Copy that cell. Select all the cells in the column and Paste
Special>Multiply>OK>Esc.

If not what you want, post back with a clearer description.

Gord Dibben Excel MVP
 
Thanks for your reply. I am a bit of a novice at Excel and just wante
to clarify if Special>Multiply>OK>Esc is pasted to the formula bar an
when you say copy that cell .7 - where is it copied to? Any detai
about this would be of assistance.
Thank
 
Hi
this has nothing to do with the formula bar. Detailed desciption:
1. Enter 0.7 in any currently blank cell.
2. Select this cell and copy this (just simply goto to the menu 'Edit -
Copy' or hit CTRL+C)
3. Now select/highlight the cell you wnat to change
4. Goto the menu entry 'Edit - Paste Special'
5. In the appearing dialog check the action type 'Multiply'
6. Hit OK and you're done

Frank
 
Hi Zerconian!

You're not actually copying the .7 anywhere. It's being used as a
multiplier. Here's a step by step:

Select an empty cell by pointing and left clicking
Type 0.7 then Enter
With this cell still selected use the commands Edit > Copy (or press
the Copy icon)
Select the range of cells that you want to adjust down by 30%
Use the commands
Edit > Paste Special
Put a dot against Multiply (you'll see this replaces the pre existing
dot in All)
Click the OK button.

You can remove that 0.7 entry now as it has done its job.

Note that this a permanent change to the data and is not by formula.
You should keep a backup file or copy your data to a new sheet and use
this sheet as your 70% sheet whilst retaining your original data.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Zerconian,

In addition to the answers from Frank and Norman just this :

When you "copy" the cell you actually do make a (temporary) copy of it in
the Windows clipboard.
This makes it possible to "paste" it later in another cell or even in an
other program (like Word for instance).

It is not really important. The answer the other two gave is much more
pointing to your "problem", but since you asked it ....


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top