Decreasing an entire column of number by a given percent 2

[Steve-vfp9user]

I have found multiple answers on my question but none of which seem to work.

I have a column of varying numbers (prices) e.g. 16.75, 21.95, 18.50 etc. There are about 1000 in our Excel 2007 spreadsheet.

If I want to reduce the reduce the price of the entire column (Column D) I tried adding -20% (And -120%) in an empty cell, copying that cell, highlighting the entire column (D) right click, paste special, Values, Multiply.

All I get is a calculation in the cell I typed 20%

What I am trying to do is change the entire column, the new amounts to be shown in that column by placing them with the minus given percent.

Thank you

Steve

 

[combo]

If I well understand, you need to reduce the prices ba 20%. In this case new prices will be 80% of old ones, insert 80% in an empty cell, copy and paste special values with multiply, as in the middle of your post above.

combo

 

[Steve-vfp9user]

Hey combo

Appreciate your post. That's been racking my brains for hours.

Cheers

Thank you

Steve

 

[SkipVought]

Hey, combo, y'all sound so suth'rn, "...ba 20%." ;-)

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[combo]

Skip, just wanted to edit it, but now - let it stay.

combo