Microsoft KB Archive/169253

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


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

Article ID: 169253

Article Last Modified on 10/21/2000



APPLIES TO

  • Microsoft Excel 97 Standard Edition



This article was previously published under Q169253


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.


Additional query words: XL97 horizontal

Keywords: kbui KB169253