Excel: Changing Column Width Causes Number to Round

ID: Q63266

The information in this article applies to:

Microsoft Excel for Windows, versions 2.1, 3.0, 4.0
Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0
Microsoft Excel for OS/2, versions 2.2 and 3.0

SUMMARY

When a number with values to the right of the decimal is entered into a cell in Microsoft Excel and the entire decimal portion of the number does not fit, the number rounds to the displayed digit. For example:

Enter 10.17453 into cell A1 and set the column width to display the entire number.

Decrease the column width so that only 10.174 can be displayed.

10.175 appears in cell A1, because the last digit (4) has been rounded up.

NOTE: Number signs (#) are displayed in a cell only if the integer portion of the number cannot fit within the current width of the cell.

Additional query words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.1 2.20 2.21 3.0 pound


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 21, 1999