XL: Wrong Value When Values Pasted with Paste Special Command

 Last reviewed: February 2, 1998
Article ID: Q139803

The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 5.0
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, versions 7.0
  • Microsoft Excel for the Macintosh, versions 4.0, 5.0

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

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.