Wrong Value When Values Pasted with Paste Special Command (139803)



The information in this article applies to:

  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 5.0
  • Microsoft Excel for Windows 4.0
  • Microsoft Excel for Windows NT 5.0
  • Microsoft Excel for the Macintosh 5.0
  • Microsoft Excel for the Macintosh 4.0

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.

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

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

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

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


Modification Type:MinorLast Reviewed:8/17/2005
Keywords:kbbug kbfix KB139803