Excel - multiply column values by one number

[JD5241]

I have a decent sized spreadsheet (750+ rows) with two columns, one for a product item number, and the other the product price. I need to mulitply every price in that particular column by 1.12. Is there a way I can update the price values in that column all at once, instead of having to go through it one at a time?

"It's a dog-eat-dog world, and I'm wearing Milk Bone underwear." - Norm

 

[SkipVought]

Hi,

Copy 1.12 from a cell

Select the Price column

Edit/Paste Special - MULTIPLY


Skip,

_[red][/red]

 

[Lilliabeth]

Save a copy of your file in case there is a mistake, then

Put 1.12 in a cell
Select the cell and click the Copy button
Select the range that has the current prices
Choose Edit > Paste Special
In the Paste Special Dialog box, choose Multiply.

Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[JD5241]

Thanks, worked like a charm!

"It's a dog-eat-dog world, and I'm wearing Milk Bone underwear." - Norm