How do I add a percentage to a row of numbers

Example: I want to add 10% to the value of each number in rows A1 through to
A500. Each cell contains a different value. (ie. 5, 6.75, 3.15 etc). I know
how to add a percentage to a single cell but is there a way you can add a set
percentage (10%)to several hundred cells at once without having to do them
all individually? Your help is very much appreciated.

Put .10 in a cell somewhere>copy it>highlight the cells to change>edit>paste
special>multiply

--
Don Guillett
SalesAid Software
[email protected]
"Messa" <[email protected]> wrote in message
news:[email protected]...
> Example: I want to add 10% to the value of each number in rows A1 through
to
> A500. Each cell contains a different value. (ie. 5, 6.75, 3.15 etc). I
know
> how to add a percentage to a single cell but is there a way you can add a
set
> percentage (10%)to several hundred cells at once without having to do them
> all individually? Your help is very much appreciated.

Select a new, empty cell.
Format it to match the cells you're looking to revise ($0.00 for example).
Enter 1.1 into this cell.
Right click and choose "Copy".
Select the cells you wish to change.
Right click in this selection and choose "PasteSpecial".
Click "Multiply", then <OK>, then <Esc>.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Messa" <[email protected]> wrote in message
news:[email protected]...
> Example: I want to add 10% to the value of each number in rows A1 through
to
> A500. Each cell contains a different value. (ie. 5, 6.75, 3.15 etc). I
know
> how to add a percentage to a single cell but is there a way you can add a
set
> percentage (10%)to several hundred cells at once without having to do them
> all individually? Your help is very much appreciated.

Maybe 1.1 Don?<bg>
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Don Guillett" <[email protected]> wrote in message
news:%[email protected]...
> Put .10 in a cell somewhere>copy it>highlight the cells to
change>edit>paste
> special>multiply
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Messa" <[email protected]> wrote in message
> news:[email protected]...
> > Example: I want to add 10% to the value of each number in rows A1
through
> to
> > A500. Each cell contains a different value. (ie. 5, 6.75, 3.15 etc). I
> know
> > how to add a percentage to a single cell but is there a way you can add
a
> set
> > percentage (10%)to several hundred cells at once without having to do
them
> > all individually? Your help is very much appreciated.
>
>

> Put .10 in a cell

or 1.1 even :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Don Guillett" <[email protected]> wrote in message
news:%[email protected]...
> Put .10 in a cell somewhere>copy it>highlight the cells to
change>edit>paste
> special>multiply
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Messa" <[email protected]> wrote in message
> news:[email protected]...
> > Example: I want to add 10% to the value of each number in rows A1
through
> to
> > A500. Each cell contains a different value. (ie. 5, 6.75, 3.15 etc). I
> know
> > how to add a percentage to a single cell but is there a way you can add
a
> set
> > percentage (10%)to several hundred cells at once without having to do
them
> > all individually? Your help is very much appreciated.
>
>

It's the thought that counts.<G>

--
Don Guillett
SalesAid Software
[email protected]
"Ragdyer" <[email protected]> wrote in message
news:[email protected]...
> Maybe 1.1 Don?<bg>
> --
> Regards,
>
> RD
>
> --------------------------------------------------------------------------
-
> Please keep all correspondence within the NewsGroup, so all may benefit !
> --------------------------------------------------------------------------
-
> "Don Guillett" <[email protected]> wrote in message
> news:%[email protected]...
> > Put .10 in a cell somewhere>copy it>highlight the cells to
> change>edit>paste
> > special>multiply
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "Messa" <[email protected]> wrote in message
> > news:[email protected]...
> > > Example: I want to add 10% to the value of each number in rows A1
> through
> > to
> > > A500. Each cell contains a different value. (ie. 5, 6.75, 3.15 etc). I
> > know
> > > how to add a percentage to a single cell but is there a way you can
add
> a
> > set
> > > percentage (10%)to several hundred cells at once without having to do
> them
> > > all individually? Your help is very much appreciated.
> >
> >
>

I have done what Messa has asked, as I had the same problem, but after I
highlight and paste, each cell doesn't have the formula in it and the number
in each cell is reduced. Clear as mud?? What am I doing wrong?

Leanne

"Messa" wrote:

> Example: I want to add 10% to the value of each number in rows A1 through to
> A500. Each cell contains a different value. (ie. 5, 6.75, 3.15 etc). I know
> how to add a percentage to a single cell but is there a way you can add a set
> percentage (10%)to several hundred cells at once without having to do them
> all individually? Your help is very much appreciated.