Paste Special - Formulas - Multiply


P

pedrorvicente

In Excel 2007, when I select Paste Special > Formulas > Multiply it
doesn't keep the formulas, it just divides the destination cell (which
has its own formulas) by the value of the formula. Previously, in
Excel 2003 it divided the cell by the pasted formula but in Excel 2007
it divides the cell by the value of the pasted formula. Is it possible
to overcome this problem?

Thanks,

PRV
 
Ad

Advertisements

B

Bob Phillips

You seem to be mixing Multiply and divide in the text, but, presuming you
mean Multiply ...

I just tried it, and you are right. This is not good is it?.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bernard Liengme

This is already on the "wish list" of things users want MS to change about
XL2007
 
B

Bob Phillips

Sounds like a a bug to me, so there should be no wish about it ...

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Ad

Advertisements

P

pedrorvicente

Sorry if I mixed multiply and divide, but it happens with both
operations.

I guess there's nothing to do about this until MS corrects the
problem.

Thanks anyway!

PRV
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top