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
ie all numbers in column B to individually have a value of -30
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gord Dibben
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
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
Z
zerconian
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
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
F
Frank Kabel
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
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
N
Norman Harker
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
A
A.W.J. Ales
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 *
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 *