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

ID: Q128332

The information in this article applies to:

Microsoft Excel for Windows, version 5.0c

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 Download Center. Click the file name below to download the file:

We1254.exe

For more information about how to download files from the Microsoft Download Center, please visit the Download Center at the following Web address

http://www.microsoft.com/downloads/search.asp

and then click How to use the Microsoft Download Center.

Additional query words: 5.00c

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