Microsoft Office Tutorials and References
In Depth Information
123456.8. The actual typed values are preserved and used in all calculations,
regardless of the display format.
The General format does not display trailing zeros. For example, if you type 123.0 ,
Excel displays 123.
A decimal fraction typed without a number to the left of the decimal point is
displayed with a zero. For example, if you type .123 , Excel displays 0.123.
The second option in the drop-down list displayed in the Number group on the Home tab
is called, helpfully, Number . When you use the drop-down list, selecting Number applies
a default number format, with two decimal places and comma separators. For example, if
you apply the Number format with a cell selected containing 1234.556, the cell displays
the number as 1,234.56. Excel rounds the decimal value to two places in the process, which
does not change the actual value in the cell, just the displayed value.
The Comma Style button in the Number group on the Home tab applies the same
format as does the Number format in the drop-down list.
In the Format Cells dialog box, the Number category contains additional options, letting
you display numbers in integer, fixed-decimal, and punctuated formats, as shown in
Figure 9-34. It is essentially the General format with additional control over displayed decimal
places, thousand separators, and negative numbers. You can use this category to format
any numbers that do not fall into any of the other categories.
Follow these guidelines when using the Number category:
● Select the number of decimal places to display (0 to 30) by typing or scrolling to the
value in the Decimal Places box.
● Select the Use 1000 Separator (,) check box to add commas between hundreds and
thousands, and so on.
Select an example in the Negative Numbers list to display negative numbers
preceded by a minus sign, in red, in parentheses, or in both red and parentheses.