XL: Wrong Value When Values Pasted with Paste Special Command

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, version 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:

Q128650 XL7 Patch Available: 15-Digit Number, Linking, and Transpose

If you are using Microsoft Excel version 5.0 for the Macintosh, see:

Q151523 MXL5: How to Install MS Excel for the Macintosh 15-Digit Patch

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

Q128332 WE1254: 15-Digit Number Patch for MS Excel Version 5.0c

Additional query words: power raise

Keywords : xlformula
Version : MACINTOSH:4.0,5.0; WINDOWS:4.0,5.0,7.0; winnt:5.0
Platform : MACINTOSH WINDOWS winnt
Issue type : kbbug