Knowledge Base

XL97: Rotated Cells Incorrectly Display Zeros

Article ID: 198159

Article Last Modified on 10/22/2000

Microsoft Excel 97 Standard Edition

This article was previously published under Q198159

SYMPTOMS

Cells display a zero value although they contain other values.

CAUSE

This problem may occur when all of the following conditions are true:

You use the General number format. -and-
You format rows to have a specific height. -and-
You format cells to have a rotated orientation.

WORKAROUND

To work around this behavior, use any of the following methods to change one of the conditions listed earlier.

Method 1: Use a Number Format Other Than General

Select the cells with rotated text.
On the Format menu, click Cells.
On the Number tab, in the Category list, click any format other than General. Click OK.

Method 2: Increase the Row Height

To adjust the height of the row to accommodate all of the text in a cell, follow these steps:

Select the cells with rotated text.
On the Format menu, point to Row, and then click AutoFit.

Method 3: Change the Rotated Text Property

Select the cells with rotated text.
On the Format menu, click Cells. Then, click the Alignment tab.
Under Orientation, type 0 (zero) in the Degrees box. Then, click OK.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

REFERENCES

For more information about rotated text, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel Help, type the following text

rotating, text

and then double-click the selected text to go to the "Center, align, indent, or rotate data in a cell" topic. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: XL97 slanted

Keywords: kbbug kbnofix KB198159