Microsoft Office Tutorials and References
In Depth Information
Formatting numbers
Figure 9-42 We created a custom format by typing codes in the Type text box.
You can create any number format using the codes in Table 9-1.
TABLE 9-1 Custom format symbols
Symbol
Meaning
0
Digit placeholder. This symbol ensures that a specified number of digits
appear on each side of the decimal point. For example, if the format is 0.000,
the value .987 is displayed as 0.987. If the format is 0.0000, the value .987 is
displayed as 0.9870. If a number has more digits to the right of the decimal
point than the number of zeros specified in the format, the number displayed
in the cell is rounded. For example, if the format is 0.00 , the value .987 is
displayed as 0.99; if the format is 0.0 , .987 is rounded to 1.0.
?
Digit placeholder. This symbol follows the same rules as the 0 placeholder,
except that space is left for insignificant zeros on either side of the decimal
point. This placeholder aligns numbers on the decimal points. For example, 1.4
and 1.45 would line up on the decimal point if both were formatted as 0.?? .
#
Digit placeholder. This symbol works like 0, except that extra zeros do not
appear if the number has fewer digits on either side of the decimal point
than # placeholders specified in the format. This symbol shows Excel where to
display commas or other separating symbols. The format #,### , for example,
tells Excel to display a comma after every third digit to the left of the decimal
point.
Search JabSto ::




Custom Search