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
Code
What It Does
General
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
“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
Table 49-2 describes the codes used to create custom formats for dates and times.
 
Search JabSto ::




Custom Search