How?In Microsoft Excel, the appearance of a number is separate from the number stored in the cell. In most circumstances, although it appears a number is rounding, only the display of the number is rounded. Calculations that use the number use the number behind the display.
You can increase the number of decimal places shown.
How?
On a worksheet
- Select the cells you want to format.
To display more or fewer digits after the decimal point, click Increase Decimal
or Decrease Decimal
on the Formatting toolbar.
In a built-in number format
On the Format menu, click Cells, and then click the Number tab.
In the Category list, click Currency, Accounting, Percentage, or Scientific.
In the Decimal places box, enter the number of decimal places you want to display.
If the column is not wide enough, the display of the number is rounded. Increase the column width.
How?
Of a single column
Drag the boundary on the right side of the column heading until the column is the width you want.
The displayed column width is the average number of digits 0 through 9 of the standard font that fit in a cell.
Of multiple columns
Select the columns you want to change, and then drag a boundary to the right of a selected column heading. To do the same for all columns on the worksheet, click the Select All 
button, and then drag the boundary of any column heading.
To fit the contents
Double-click the boundary to the right of the column heading. To do the same for all columns on the worksheet, click the Select All button, and then double-click a boundary to the right of one of the column headings.
To a specific width
Select the column, point to Column on the Format menu, click Width, and then enter a number.
To match another column
on the Standard toolbar, and then select the target column.
Define the default column width
- To define the default column width for all worksheets in a workbook, select all worksheets.
When you enter or change data, the changes affect all selected sheets. These changes may replace data on the active sheet and other selected sheets.
To select Do this A single sheet Click the sheet tab.
If you don't see the tab you want, click the tab scrolling buttons to display the tab, and then click the tab.
Two or more adjacent sheets Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet. Two or more nonadjacent sheets Click the tab for the first sheet, and then hold down CTRL and click the tabs for the other sheets. All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu.
Note If sheet tabs have been color-coded, the sheet tab name will be underlined in a user-specified color when selected. If the sheet tab is displayed with a background color, the sheet has not been selected.
To cancel a selection of multiple sheets in a workbook, click any unselected sheet.
If no unselected sheet is visible, right-click the tab of a selected sheet. Then click Ungroup Sheets on the shortcut menu.
- On the Format menu, point to Column, and then click Standard Width.
- Type a new measurement.
The number that appears in the Standard column width box is the average number of digits 0-9 of the standard font that fit in a cell.
To define the default column width for all new workbooks and worksheets, create a workbook template and a worksheet template.
Of a single row
Drag the boundary below the row heading until the row is the height you want.
Of multiple rows
Select the rows you want to change, and drag a boundary below a selected row heading. To change the row height for all rows on the worksheet, click the Select All button, and then drag the boundary below any row heading.
To fit the contents
Double-click the boundary below the row heading.
To a specific height
Select the column, point to Row on the Format menu, click Height, and then enter a number.
