XL: Wrong Value When Values Pasted with Paste Special Command

ID: Q139803

The information in this article applies to:

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.

If you are using Microsoft Excel version 7.0 for Windows 95, see: 

   ARTICLE-ID: Q128650
   TITLE     : XL7 Patch Available: 15-Digit Number, Linking, and Transpose
If you are using Microsoft Excel version 5.0 for the Macintosh, see: 

   ARTICLE-ID: Q151523
   TITLE     : MXL5: How to Install MS Excel for the Macintosh 15-Digit
               Patch
If you are using Microsoft Excel version 5.0 for Windows, see: 

   ARTICLE-ID: Q128332
   TITLE     : WE1254: 15-Digit Number Patch for MS Excel Version 5.0c
Additional query words: power raise 4.00 5.00 7.00 

Keywords          : xlformula kbfixlist
Version           : WINDOWS:4.0,5.0,7.0; MACINTOSH:4.0
Platform          : MACINTOSH WINDOWS
Issue type        : kbbug
Solution Type     : kbfix

Last Reviewed: February 6, 1998