Microsoft KB Archive/139803

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.