Microsoft Knowledge Base

General Number Value Displays Differently in Print Preview
Last reviewed: March 27, 1997
Article ID: Q123070
3.00 4.00 5.00 5.00c 7.00 | 3.00 4.00 5.00 
WINDOWS                   | MACINTOSH
kbprint

The information in this article applies to:

  • Microsoft Excel for Windows, versions 3.0, 4.0, 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 3.0, 4.0, 5.0
  • Microsoft Excel for Windows 95, version 7.0

SYMPTOMS

In Microsoft Excel, under certain conditions, a numeric value in a cell formatted with the General number format displays a different value on the screen than in print preview, or on the printed worksheet.

In Microsoft Excel versions 5.0 and 7.0, this behavior may also occur on a zoomed worksheet.

CAUSE

When you apply the General number format to a value in a cell, the value is rounded to the nearest decimal place that can of be displayed within the given column width. Under certain conditions, the column width available is calculated differently for the screen display than it is for print preview or the printed worksheet. The result is that one or more of these graphic outputs may display the rounded value while the other displays the non- rounded value.

Note that this behavior depends on the resolution of the video driver that you are using as well as the formatting applied to the cells.

WORKAROUND

To avoid this behavior, increase the width of the column that contains the cell with the General formatting to prevent the vale from being rounded, or apply a different number formatting to the affected cells.

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.

REFERENCES

"User's Guide," version 5.0, Chapter 12, "Applying Number Formats"

KBCategory: kbprint
KBSubcategory:

Additional reference words: 3.00 4.00 5.00 5.00c round mismatch error
Keywords : kbprint
Version : 3.00 4.00 5.00 5.00c 7.00 | 3.00
Platform : MACINTOSH WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.