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)



wrote in message
...
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