Re: Paste Special - Formulas - Multiply

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <bob.NGs@xxxxxxxxxxxxx> wrote in message
news:eumkL2yZIHA.5164@xxxxxxxxxxxxxxxxxxxxxxx
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)



<pedrorvicente@xxxxxxxxx> wrote in message
news:b5f52a01-4a90-4b6e-9b53-dbc7ae6602b6@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: Paste Special - Formulas - Multiply
    ... Microsoft Excel MVP ... 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. ...
    (microsoft.public.excel.misc)
  • Paste Special - Formulas - Multiply
    ... 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. ...
    (microsoft.public.excel.misc)
  • Re: Cell displays formula instead of the formulas result
    ... My first guess is that the numberformat is changed to General after the formula ... And changing the numberformat isn't enough to make excel ... change the value in that cell. ... problem so that the pasted formula displays correctly? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: How can I undo an unintended change?
    ... > When I type an entry into Excel 97, it divides the number by one ... the cell will show 0.96. ... > number, currency, etc. Protection on or off, doesn't matter. ...
    (microsoft.public.excel.misc)
  • Re: Excel automatically divides number by 100
    ... David Biddulph ... I am having a problem with Excel. ... Whenever I enter a number in a cell, ... divides it by 100 and then stores it. ...
    (microsoft.public.excel.misc)