Adding a % value to a column of numbers
 

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

Adding a % value to a column of numbers
 

Morefeus Direct wrote:
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.

Adding a % value to a column of numbers
 

Type 1.25 in an unused cell.

Copy that cell.

Select the column of numbers and EditPaste SpecialMultiplyOKEsc.

Delete the cell with the 1.25


Gord Dibben MS Excel MVP


On Fri, 15 Sep 2006 17:03:02 -0700, Morefeus Direct
wrote:

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

Adding a % value to a column of numbers
 

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

"Morefeus Direct" wrote:

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

Adding a % value to a column of numbers
 

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

" wrote:

Morefeus Direct wrote:
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.

Adding a % value to a column of numbers
 

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" wrote:

Type 1.25 in an unused cell.

Copy that cell.

Select the column of numbers and EditPaste SpecialMultiplyOKEsc.

Delete the cell with the 1.25


Gord Dibben MS Excel MVP


On Fri, 15 Sep 2006 17:03:02 -0700, Morefeus Direct
wrote:

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

Adding a % value to a column of numbers
 

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

On Sat, 16 Sep 2006 06:48:01 -0700, Morefeus Direct
wrote:

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" wrote:

Type 1.25 in an unused cell.

Copy that cell.

Select the column of numbers and EditPaste SpecialMultiplyOKEsc.

Delete the cell with the 1.25


Gord Dibben MS Excel MVP


On Fri, 15 Sep 2006 17:03:02 -0700, Morefeus Direct
wrote:

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

Adding a % value to a column of numbers
 

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" wrote:

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

On Sat, 16 Sep 2006 06:48:01 -0700, Morefeus Direct
wrote:

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" wrote:

Type 1.25 in an unused cell.

Copy that cell.

Select the column of numbers and EditPaste SpecialMultiplyOKEsc.

Delete the cell with the 1.25


Gord Dibben MS Excel MVP


On Fri, 15 Sep 2006 17:03:02 -0700, Morefeus Direct
wrote:

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

Adding a % value to a column of numbers
 

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


" wrote:

Morefeus Direct wrote:
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.

Adding a % value to a column of numbers
 

Assuming the column of letters is A

In B1 enter =A1 & ".jpg"

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


Gord

On Sat, 16 Sep 2006 12:51:02 -0700, Morefeus Direct
wrote:

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" wrote:

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

On Sat, 16 Sep 2006 06:48:01 -0700, Morefeus Direct
wrote:

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" wrote:

Type 1.25 in an unused cell.

Copy that cell.

Select the column of numbers and EditPaste SpecialMultiplyOKEsc.

Delete the cell with the 1.25


Gord Dibben MS Excel MVP


On Fri, 15 Sep 2006 17:03:02 -0700, Morefeus Direct
wrote:

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





Gord Dibben MS Excel MVP