Adding a % value to a column of numbers

[Guest]

hello anyone how can help, i'm new to exel ,now in exel i have a column of
different number like 512.00,654.00,68.56, and so on down this colunm and i
want to add say, 25% to all the values in this column, how do i do it?

there are over 1000 different number combinations in this column.

Please help
Morefeus Direct.com

 

[joeu2004]

hello anyone how can help, i'm new to exel ,now in exel i have a column of
different number like 512.00,654.00,68.56, and so on down this colunm and i
want to add say, 25% to all the values in this column, how do i do it?

Two possible ways, depending on what outcome you want.

1. If you want the +25% value in another column, then if the original
numbers are in A1:A1000, put the following formula into B1 and copy
down through B1000:

=A1*1.25

2. If you want the original numbers to be overwritten with their value
+25%, put 1.25 into some cell (say B1), then right-click B1 and select
Copy, then highlight A1:A1000, right-click and select Paste Special,
then select Multiply. You can delete the value in B1, if you like.

 

[Gord Dibben]

Type 1.25 in an unused cell.

Copy that cell.

Select the column of numbers and Edit>Paste Special>Multiply>OK>Esc.

Delete the cell with the 1.25


Gord Dibben MS Excel MVP

 

[Guest]

thanks for the reply but it still did'nt work, when i do what you ask it
either changes all the values to 0 or it multiplies that value by its self.

please help

 

[Guest]

thanks for the reply but it still did'nt work, when i do what you ask it
either changes all the values to 0 or it multiplies that value by its self.

please help

 

[Guest]

thank you for you reply but when i do as you ask it still does'nt work, it
either changes the value to 0 or it multiplies that value by its self.

please help

 

[Guest]

thank you for you reply but when i do as you ask it still does'nt work, it
either changes the value to 0 or it multiplies that value by its self.

please help

 

[Guest]

thank you for you reply but when i do as you ask it still does'nt work, it
either changes the value to 0 or it multiplies that value by its self.

please help

 

[Guest]

thank you for you reply but when i do as you ask it still does'nt work, it
either changes the value to 0 or it multiplies that value by its self.

please help

 

[Gord Dibben]

I think what you are doing is hitting Enter key when you should be hitting Esc
key.

Follow my instructions to the letter and see what happens.


Gord

 

[Gord Dibben]

I think what you are doing is hitting Enter key when you should be hitting Esc
key.

Follow my instructions to the letter and see what happens.


Gord

 

[Guest]

hello Gord,
thank you you were right about that,now i have anouther question,ok now i
have a exel sheet with in one column all the way down 1000 different letters
like , abt2mm,hgt3nn,jhl700 and so on now i'd like to add .jpg on the end of
all these letters to look like, abt2mm.jpg,hgt3nn.jpg and so on can you help
me to do this, i know its a formula like A1= something but i can remember.

help please

 

[Guest]

hello Gord,
thank you you were right about that,now i have anouther question,ok now i
have a exel sheet with in one column all the way down 1000 different letters
like , abt2mm,hgt3nn,jhl700 and so on now i'd like to add .jpg on the end of
all these letters to look like, abt2mm.jpg,hgt3nn.jpg and so on can you help
me to do this, i know its a formula like A1= something but i can remember.

help please

 

[Guest]

hello Joe,
thank you you were right about that,now i have anouther question,ok now i
have a exel sheet with in one column all the way down 1000 different letters
like , abt2mm,hgt3nn,jhl700 and so on now i'd like to add .jpg on the end of
all these letters to look like, abt2mm.jpg,hgt3nn.jpg and so on can you help
me to do this, i know its a formula like A1= something but i can remember.

help please

 

[Guest]

hello Joe,
thank you you were right about that,now i have anouther question,ok now i
have a exel sheet with in one column all the way down 1000 different letters
like , abt2mm,hgt3nn,jhl700 and so on now i'd like to add .jpg on the end of
all these letters to look like, abt2mm.jpg,hgt3nn.jpg and so on can you help
me to do this, i know its a formula like A1= something but i can remember.

help please

 

[Gord Dibben]

Assuming the column of letters is A

In B1 enter =A1 & ".jpg"

Double-click on fill handle of B1 to copy down.


Gord

hello Gord,
thank you you were right about that,now i have anouther question,ok now i
have a exel sheet with in one column all the way down 1000 different letters
like , abt2mm,hgt3nn,jhl700 and so on now i'd like to add .jpg on the end of
all these letters to look like, abt2mm.jpg,hgt3nn.jpg and so on can you help
me to do this, i know its a formula like A1= something but i can remember.

help please

Gord Dibben MS Excel MVP

 

[Gord Dibben]

Assuming the column of letters is A

In B1 enter =A1 & ".jpg"

Double-click on fill handle of B1 to copy down.


Gord

hello Gord,
thank you you were right about that,now i have anouther question,ok now i
have a exel sheet with in one column all the way down 1000 different letters
like , abt2mm,hgt3nn,jhl700 and so on now i'd like to add .jpg on the end of
all these letters to look like, abt2mm.jpg,hgt3nn.jpg and so on can you help
me to do this, i know its a formula like A1= something but i can remember.

help please

Gord Dibben MS Excel MVP