Microsoft Office Tutorials and References
In Depth Information
Parts of a number format string
Table 16-1: Codes Used to Create Custom Number Formats
Code
What It Does
General
Displays the number in General format.
#
Serves as a digit placeholder that displays only significant digits and doesn’t display
insignificant zeros.
0 (zero)
Serves as a digit placeholder that displays insignificant zeros if a number has fewer digits
than there are zeros in the format.
?
Serves as a digit placeholder that adds spaces for insignificant zeros on either side of the
decimal point so that decimal points align when formatted with a fixed-width font; also
used for fractions that have varying numbers of digits.
.
Displays the decimal point.
%
Displays a percentage.
,
Displays the thousands separator.
E- E+ e- e+
Displays scientific notation.
$ – + / ( ) : space
Displays the actual character.
\
Displays the next character in the format.
*
Repeats the next character to fill the column width.
_ (underscore)
Leaves a space equal to the width of the next character.
“text”
Displays the text inside the double quotation marks.
@
Serves as a text placeholder.
[color]
Displays the characters in the specified color and can be any of the following text strings
(not case-sensitive): Black, Blue, Cyan, Green, Magenta, Red, White, or Yellow.
[COLOR n]
Displays the corresponding color in the color palette, where n is a number from 0 to 56.
[condition value]
Enables you to set your own criteria for each section of a number format.
Search JabSto ::




Custom Search