Microsoft Office Tutorials and References
In Depth Information
Custom number format codes
Custom number format codes
Table 49-1 briefly describes the formatting codes available for custom formats.
Table 49-1: Codes Used to Create Custom Number Formats
What It Does
Displays the number in General format
Serves as a digit placeholder that displays only significant digits and does not
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 this 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
Displays the text inside the double quotation marks
Serves as a text placeholder
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
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
Table 49-2 describes the codes used to create custom formats for dates and times.
Search JabSto ::

Custom Search