In Excel how do I increase the amount in an entire column by a %?

[Brittany]

I need to increase all the numbers in a column by 10%. Can anyone help me?

[tim m]

If your original number was in A1 you could use the formula below.

=A1*1.1

"Brittany" wrote:

> I need to increase all the numbers in a column by 10%. Can anyone help me?

[Marcelo]

type 1.1 in on cell, copy it and paste special as multiply

HTH
Regards from Brazil
Marcelo

"tim m" escreveu:

> If your original number was in A1 you could use the formula below.
>
> =A1*1.1
>
> "Brittany" wrote:
>
> > I need to increase all the numbers in a column by 10%. Can anyone help me?

[Don Guillett]

in a cell somewhere put 1.1
copy that cell
select your range
edit>paste>multiply

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"Brittany" <Brittany@discussions.microsoft.com> wrote in message
news:04EDA7B6-D8F9-40B1-A55B-C0FFB0E4D1F4@microsoft.com...
>I need to increase all the numbers in a column by 10%. Can anyone help me?

[bpeltzer]

In some empty cell, enter the number 1.1. Copy (ctrl+c) that cell. Then
select your column of numbers and Edit > Paste Special. Select VALUES and
MULTIPLY then click OK.

"Brittany" wrote:

> I need to increase all the numbers in a column by 10%. Can anyone help me?