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

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

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

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?

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

in a cell somewhere put 1.1
copy that cell
select your range
editpastemultiply

--
Don Guillett
SalesAid Software

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

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

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?

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

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?