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

ID: Q128332

The information in this article applies to:

SUMMARY

The Application Note "15-Digit Number Patch for Version 5.0c" (WE1254) is now available from Microsoft Product Support Services (PSS). The files included with this Application Note contain a patch that corrects problems you may encounter when you enter the following numbers in a Microsoft Excel worksheet: 


   140737488355328

   281474976710656

   562949953421312
Note that these numbers are 2 to the 47th, 48th, or 49th power, respectively. If you enter a variation of these numbers (for example, 1.40737488355328), or if you calculate a variation of one of these numbers, the number may be resolved to a different value, such as 0.64 (or some multiple of 0.64). The problem also appears when one of these numbers is the result of one of the following functions: CEILING(), FLOOR(), IF(), INT(), MOD(), ROUNDDOWN(), or ROUNDUP().

This problem applies only to these particular numbers. Other 15-digit numbers are not affected.


MORE INFORMATION

The following file is available for download from the Microsoft Software Library:

WE1254.exe
For more information about downloading files from the Microsoft Software Library, please see the following article in the Microsoft Knowledge Base:
Q119591 How to Obtain Microsoft Support Files from Online Services

Additional query words: 5.00c 


Keywords          : xlwin 
Version           : WINDOWS:5.0c
Platform          : WINDOWS 
Issue type        :

Last Reviewed: June 25, 1999