software

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?

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 2000quot;Morefeus Directquot; wrote:

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

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 gt;,
Morefeus Direct lt;Morefeus gt; wrote:

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

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

quot;JE McGimpseyquot; wrote:

gt; Enter your increase in a blank cell, e.g., to increase by 6%, enter
gt;
gt; 1.06
gt;
gt; in a blank cell. Copy the cell. Select the prices to change. Choose
gt; Edit/Paste Special, selecting the Values and Multiply radio buttons.
gt; Click OK.
gt;
gt; In article gt;,
gt; Morefeus Direct lt;Morefeus gt; wrote:
gt;
gt; gt; i have the stadard excel worksheet up , now in line A i have prices all the
gt; gt; way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
gt; gt; to each of these price value, with out having to do one at a time , how do i
gt; gt; do this?
gt;

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

quot;BillyRogersquot; wrote:

gt; enter in cell b2 =a1*1.15 (for a 15% increase)
gt; and copy the cell all the way down to row 1000. You can click on the cell
gt; after entering the formula and then click and hold on the little black square
gt; in the lower right hand corner of the highlighted cell and pull the mouse
gt; cursor all the way down to row 1000 to copy the formula.
gt;
gt; --
gt; Billy Rogers
gt;
gt; Dallas,TX
gt;
gt; Currently Using Office 2000
gt;
gt;
gt; quot;Morefeus Directquot; wrote:
gt;
gt; gt; i have the stadard excel worksheet up , now in line A i have prices all the
gt; gt; way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
gt; gt; to each of these price value, with out having to do one at a time , how do i
gt; gt; do this?

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
quot;JE McGimpseyquot; wrote:

gt; Enter your increase in a blank cell, e.g., to increase by 6%, enter
gt;
gt; 1.06
gt;
gt; in a blank cell. Copy the cell. Select the prices to change. Choose
gt; Edit/Paste Special, selecting the Values and Multiply radio buttons.
gt; Click OK.
gt;
gt; In article gt;,
gt; Morefeus Direct lt;Morefeus gt; wrote:
gt;
gt; gt; i have the stadard excel worksheet up , now in line A i have prices all the
gt; gt; way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
gt; gt; to each of these price value, with out having to do one at a time , how do i
gt; gt; do this?
gt;

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 johnsonquot;BillyRogersquot; wrote:

gt; enter in cell b2 =a1*1.15 (for a 15% increase)
gt; and copy the cell all the way down to row 1000. You can click on the cell
gt; after entering the formula and then click and hold on the little black square
gt; in the lower right hand corner of the highlighted cell and pull the mouse
gt; cursor all the way down to row 1000 to copy the formula.
gt;
gt; --
gt; Billy Rogers
gt;
gt; Dallas,TX
gt;
gt; Currently Using Office 2000
gt;
gt;
gt; quot;Morefeus Directquot; wrote:
gt;
gt; gt; i have the stadard excel worksheet up , now in line A i have prices all the
gt; gt; way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
gt; gt; to each of these price value, with out having to do one at a time , how do i
gt; gt; do this?

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 johnsonquot;JE McGimpseyquot; wrote:

gt; Enter your increase in a blank cell, e.g., to increase by 6%, enter
gt;
gt; 1.06
gt;
gt; in a blank cell. Copy the cell. Select the prices to change. Choose
gt; Edit/Paste Special, selecting the Values and Multiply radio buttons.
gt; Click OK.
gt;
gt; In article gt;,
gt; Morefeus Direct lt;Morefeus gt; wrote:
gt;
gt; gt; i have the stadard excel worksheet up , now in line A i have prices all the
gt; gt; way downfrom 1 to 1000 all diferent prices. now i want to add a persentage
gt; gt; to each of these price value, with out having to do one at a time , how do i
gt; gt; do this?
gt;