Microsoft KB Archive/141179

= Microsoft Knowledge Base =

MXL: Cannot Set Row Height to a Decimal Value
Last reviewed: September 12, 1996

Article ID: Q141179

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 2.2, 2.2a, 3.0, 3.0a, 4.0, 5.0, 5.0a
 * Microsoft Excel for the Power Macintosh, versions 5.0, 5.0a

SYMPTOMS
In Microsoft Excel for the Macintosh, when you enter a row height as a decimal value, the number is rounded to a whole number.

STATUS
Microsoft has confirmed this to be a problem in the versions of Microsoft Excel 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.

MORE INFORMATION
To set the height of a row, use the appropriate procedure for your version of Microsoft Excel.

Method 1: Microsoft Excel version 5.0

1. On the Format menu, point to Row, and then click Height.

2. Enter any number in the Row Height box, and then click OK. Method 2: Microsoft Excel versions 2.2, 3.0, and 4.0

1. On the Format menu, click Row Height.

2. Enter any number in Row Height box, and then click OK. After you use either of these methods, the number that you entered for the row height may be rounded down to the nearest multiple of .25. For example, if you set the row height to 14.9 and then select the row height in the row height dialog box, the value 14.75 will be displayed.

If you place the insertion point on the border between the row for which you just changed the height and the next row, and then click and hold down your mouse button, the actual height of the row (14.00 in this example) is displayed in the reference box of the formula bar. Microsoft Excel takes the number you enter for the row height and sets the actual row height to the integer portion of that number.