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

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.

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


On Fri, 15 Sep 2006 17:03:02 -0700, Morefeus Direct
<(E-Mail Removed)> 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

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

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

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 Edit>Paste Special>Multiply>OK>Esc.
>
> Delete the cell with the 1.25
>
>
> Gord Dibben MS Excel MVP
>
>
> On Fri, 15 Sep 2006 17:03:02 -0700, Morefeus Direct
> <(E-Mail Removed)> 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
>
>

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

"(E-Mail Removed)" 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.
>
>

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 Edit>Paste Special>Multiply>OK>Esc.
>
> Delete the cell with the 1.25
>
>
> Gord Dibben MS Excel MVP
>
>
> On Fri, 15 Sep 2006 17:03:02 -0700, Morefeus Direct
> <(E-Mail Removed)> 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
>
>

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

"(E-Mail Removed)" 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.
>
>

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
<(E-Mail Removed)> 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 Edit>Paste Special>Multiply>OK>Esc.
>>
>> Delete the cell with the 1.25
>>
>>
>> Gord Dibben MS Excel MVP
>>
>>
>> On Fri, 15 Sep 2006 17:03:02 -0700, Morefeus Direct
>> <(E-Mail Removed)> 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
>>
>>