Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special - Formulas - Multiply
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special - Formulas - Multiply
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special - Formulas - Multiply
This is already on the "wish list" of things users want MS to change about
XL2007 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob Phillips" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special - Formulas - Multiply
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) "Bernard Liengme" wrote in message ... This is already on the "wish list" of things users want MS to change about XL2007 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Bob Phillips" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste Special - Formulas - Multiply
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit Paste Special Formulas | Excel Worksheet Functions | |||
Paste Special - Formulas - Add | Excel Worksheet Functions | |||
paste special - formulas | Excel Worksheet Functions | |||
Paste special formulas? | Excel Discussion (Misc queries) | |||
Paste Special - All but formulas | Excel Worksheet Functions |