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. (This tag does not support international number formatting.)
| 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. |
For a code example, see cfgrid.