XL97: Cell Displays Zero with Angled Text and Small Row Height

Last reviewed: January 9, 1998
Article ID: Q169253
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS

When changing the height of a row in Microsoft Excel, any cell in the row displays a zero instead of its proper contents.

CAUSE

This problem occurs if the following conditions are true:

  • You format the cell to use text that is angled in a range between -41 and +41 degrees orientation.

        -and-
    
  • You recently decreased the height of the row that contains the cell in question.

        -and-
    
  • The number format of the cell is the General format.

WORKAROUND

If you apply a number format to the cell in question, the problem no longer occurs. To do this, use the following steps:

  1. Select the cell with the angled text. On the Format menu, click Cells.

  2. In the Format Cells dialog box, click the Number tab. Select the category and number format that you want to display. Click OK.

STATUS

Microsoft has confirmed this to be a problem in the products listed at the beginning of this article. We are researching this problem and will post more information here in the Microsoft Knowledge Base as it becomes available.


Additional query words: XL97 horizontal
Keywords : xlui kbui
Version : WINDOWS:97
Platform : 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: January 9, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.