how to multiply a column by a percentage without blank cells being replaced by 0

[boag]

how do i multiply a column by a percentage without blank cells being replaced by 0 in

i have ried the following to change the percentage of the collumn, but all the blank cells atomatically turn to zero's...
help please?:


Consider this scenario: Your company's product price list stored in a worksheet. Your boss informs you that, effective immediately, all prices must be increased by 5 percent.

You could create some formulas to do the math, and then convert the formulas to values, and then copy and paste the new prices over the old prices. Or, you could use this more efficient method:

1. Enter 1.05 into any blank cell. This is the "multiplier" that will increase the prices by 5 percent.
2. Select the cell you used in Step 1, and choose Edit, Copy or press Ctrl-C.
3. Select the range of values to be changed, and choose Edit, Paste Special to display the Paste Special dialog box.
4. Choose the Multiply option and click OK.

Voilą! The values are changed in an instant. You can then delete the cell that contains the 1.05 multiplier.

Note that the Paste Special dialog box lets you carry out other mathematical operations--like add and subtract, for instance--so you can use this technique for a variety of other calculations.

[Special-K]

Hold down Ctrl and only select the fields you want.
Messy but cant see another way unless someone else comes up with something.

[boag]

thanks, but ii think it would be qicker just to delete the zeros.

regards

[JBeaucaire]

1) Enter your multiplication value in an empty cell
2) Copy it
3) Highlight your range of prices including blank cells
4) Press F5, click SPECIAL > Constant > OK
5) Edit > Paste Special > Multiply > OK

[boag]

wow...

worked a treat

great, thanks.

[boag]

wow...

worked a treat

great, thanks.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.