how to add a % to amounts in excel
 

i have the stadard excel worksheet up , now in line A i have prices all the
way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
to each of these price value, with out having to do one at a time , how do i
do this?

how to add a % to amounts in excel
 

enter in cell b2 =a1*1.15 (for a 15% increase)
and copy the cell all the way down to row 1000. You can click on the cell
after entering the formula and then click and hold on the little black square
in the lower right hand corner of the highlighted cell and pull the mouse
cursor all the way down to row 1000 to copy the formula.

--
Billy Rogers

Dallas,TX

Currently Using Office 2000


"Morefeus Direct" wrote:

i have the stadard excel worksheet up , now in line A i have prices all the
way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
to each of these price value, with out having to do one at a time , how do i
do this?

how to add a % to amounts in excel
 

Enter your increase in a blank cell, e.g., to increase by 6%, enter

1.06

in a blank cell. Copy the cell. Select the prices to change. Choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.
Click OK.

In article ,
Morefeus Direct <Morefeus wrote:

i have the stadard excel worksheet up , now in line A i have prices all the
way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
to each of these price value, with out having to do one at a time , how do i
do this?

how to add a % to amounts in excel
 

hey,ge still can't get this can you explain it in newbe terms

"JE McGimpsey" wrote:

Enter your increase in a blank cell, e.g., to increase by 6%, enter

1.06

in a blank cell. Copy the cell. Select the prices to change. Choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.
Click OK.

In article ,
Morefeus Direct <Morefeus wrote:

i have the stadard excel worksheet up , now in line A i have prices all the
way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
to each of these price value, with out having to do one at a time , how do i
do this?

how to add a % to amounts in excel
 

hey billy, still can't get it is there a better way or explain this for newbe's

"BillyRogers" wrote:

enter in cell b2 =a1*1.15 (for a 15% increase)
and copy the cell all the way down to row 1000. You can click on the cell
after entering the formula and then click and hold on the little black square
in the lower right hand corner of the highlighted cell and pull the mouse
cursor all the way down to row 1000 to copy the formula.

--
Billy Rogers

Dallas,TX

Currently Using Office 2000


"Morefeus Direct" wrote:

i have the stadard excel worksheet up , now in line A i have prices all the
way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
to each of these price value, with out having to do one at a time , how do i
do this?

how to add a % to amounts in excel
 

thanks JE that worked out fine , another question is there a way to convert
a^ (shift +6) delimted.dat file to a csv file ?

help!
M johnson
"JE McGimpsey" wrote:

Enter your increase in a blank cell, e.g., to increase by 6%, enter

1.06

in a blank cell. Copy the cell. Select the prices to change. Choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.
Click OK.

In article ,
Morefeus Direct <Morefeus wrote:

i have the stadard excel worksheet up , now in line A i have prices all the
way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
to each of these price value, with out having to do one at a time , how do i
do this?

how to add a % to amounts in excel
 

thanks Billy that worked out fine , another question is there a way to
convert a^ (shift +6) delimted.dat file to a csv file ?

help!
M johnson


"BillyRogers" wrote:

enter in cell b2 =a1*1.15 (for a 15% increase)
and copy the cell all the way down to row 1000. You can click on the cell
after entering the formula and then click and hold on the little black square
in the lower right hand corner of the highlighted cell and pull the mouse
cursor all the way down to row 1000 to copy the formula.

--
Billy Rogers

Dallas,TX

Currently Using Office 2000


"Morefeus Direct" wrote:

i have the stadard excel worksheet up , now in line A i have prices all the
way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
to each of these price value, with out having to do one at a time , how do i
do this?

how to add a % to amounts in excel
 

thanks JE that worked out fine , another question is there a way to convert
a^ (shift +6) delimted.dat file to a csv file ?

help!
M johnson


"JE McGimpsey" wrote:

Enter your increase in a blank cell, e.g., to increase by 6%, enter

1.06

in a blank cell. Copy the cell. Select the prices to change. Choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.
Click OK.

In article ,
Morefeus Direct <Morefeus wrote:

i have the stadard excel worksheet up , now in line A i have prices all the
way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
to each of these price value, with out having to do one at a time , how do i
do this?