User Guide
cfgridcolumn 165
numberFormat mask characters
You can use the following
numberFormat attribute mask characters, which correspond to those in
the
NumberFormat function, to format output in U.S. numeric and currency styles. For more
information, see
NumberFormat on page 631. (This tag does not support international number
formatting.)
Example
For a code example, see cfgrid on page 152.
Character Meaning
_ (Underscore) Digit placeholder.
9 Digit placeholder.
. (Period) Location of mandatory decimal point.
0 Located to left or right of mandatory decimal point; pads with zeros.
( ) Puts parentheses around mask if number is less than 0.
+ Puts plus sign before positive numbers, minus sign before negative numbers.
- Puts space before positive numbers, minus sign before negative numbers.
, (Comma) Separates every third decimal-place with a comma.
L,C Left-justify or center-justify number within width of mask column. First character of
mask must be L or C. Default: right-justified.
$ Puts dollar sign before formatted number. Must be the first character of mask.
^ (Caret) Separates left from right formatting.