The number formatting mask uses the following syntax:
[-|+] [Z|P] [B] [C] [n][.m] [@r | % | $ | [CUR] ]
Mask |
Description |
---|---|
+ |
Displays + for positive values and - for negative values. |
- |
Displays a space for positive values and - for negative values. |
Z |
Displays insignificant digits as zeros. |
P |
Displays insignificant digits as spaces. |
B |
Displays a space when the value is zero, regardless of other codes. |
C |
Inserts a thousands separator into the number. |
N |
Number of digits to display to the left of the decimal point. If omitted, only the significant digits are displayed. |
.m |
Number of digits to display to the right of the decimal point. If omitted, only the significant digits are displayed. |
@r |
Displays numbers using radix r (2 - 36). |
% |
Displays numbers as a percentage of 100. |
$ |
Inserts the locale-specific currency code. |
[CUR] |
Inserts the given currency code. The currency code must be enclosed in brackets (such as [USD] or [EUR]). |
NORMAL |
Displays the number in standard format. |