Certain Numbers Ending in .848 Display Incorrectly (142981)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows 4.0
- Microsoft Excel for Windows 3.0
- Microsoft Excel for Windows NT 5.0
This article was previously published under Q142981 SYMPTOMS
On a Microsoft Excel worksheet, when you enter a number between 32,768 and
65,535 that has a decimal portion of .848, the number is displayed in the
formula bar with a decimal portion of .8479999999.
RESOLUTION
The default general number format displays the number in the cell with the
correct decimal portion. The cell will display the same number as the
number in the formula bar if you format the cell to show 10 decimal places
or more.
To format the cell to show 10 decimal places or more, do the following: - On the Format menu, click Cells, and in the Format Cells dialog box,
click the Number tab.
- Under Category, click Number.
- If you are running Microsoft Excel for Windows 95:
Under Decimal Places, change the default value of 2 to 10 or more.
Under Format Codes, create a code with 10 decimal places or more.
- Click OK.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | kbprb KB142981 |
|---|
|