Microsoft Office Tutorials and References

In Depth Information

**Formatting numbers**

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.

●

Formatting numbers

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.

Note

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.

●