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
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