Specifications

CHAPTER 8 Displaying and Validating Data
Users Guide 267
String display formats
String display formats can have two sections. The first is required and contains
the format for strings; the second is optional and specifies how to represent
NULLs:
string-format;null-format
In a string format mask, each at-sign (@) represents a character in the string
and all other characters represent themselves.
Special characters for string edit masks
String edit masks use different special characters. See “The EditMask edit
style” on page 278.
Example
This format mask:
[red](@@@) @@@-@@@@
displays the string 800YESCELT in red as:
(800) YES-CELT
Date display formats
Date display formats can have two sections. The first is required and contains
the format for dates; the second is optional and specifies how to represent
NULLs:
date-format;null-format
$#,##0;-$#,##0 $5 -$5 $1
$#,##0;[RED]($#,##0) $5 ($5) $1
[Currency] $5.00 ($5.00) $0.50
$#,##0.00;($#,##0.00) $5.00 ($5.00) $0.50
$#,##0.00;[RED]($#,##0.00) $5.00 ($5.00) $0.50
##0% 500% -500% 50%
##0.00% 500.00% -500.00% 50.00%
0.00E+00 5.00E+00 -5.00E+00 5.00E-01
Format 5 -5 .5