Microsoft KB Archive/139803

From BetaArchive Wiki
Knowledge Base


Wrong Value When Values Pasted with Paste Special Command

Article ID: 139803

Article Last Modified on 6/11/2007



APPLIES TO

  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 4.0 Standard Edition
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 5.0 for Macintosh
  • Microsoft Excel 4.0 for Macintosh



This article was previously published under Q139803

SYMPTOMS

When you use a formula that divides the number 1 by the number 1.25 raised to the 16th power and attempt to paste only the value from the formula into another cell, an incorrect value is pasted.

When the result value of the following formula (0.028147) is pasted into a cell

=1/(1.25^16)


the value 0.01 is pasted instead of the correct value.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows 95, version 7.0a. This problem was also corrected with a patch. For information about this patch, the appropriate article in the Microsoft Knowledge Base.


Additional query words: power raise XL

Keywords: kbbug kbfix KB139803