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

ID: Q179033


The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition


SYMPTOMS

When you change the height of a row in Microsoft Excel 98 Macintosh Edition, 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 (other than General) to the cell in question, the problem no longer occurs. To do this, follow these 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 new information here in the Microsoft Knowledge Base as it becomes available.


REFERENCES

For more information about formatting cells, click Contents and Index on the Help menu. Click the Index button, and type the following text:

formatting cells, overview
and then double-click the selected text to go to the "Basic worksheet formatting" topic.

Additional query words: horizontal XL98

Keywords : xlui
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug


Last Reviewed: January 13, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.