Show TOC

Background documentationNumber Formatting Mask Locate this document in the navigation structure

 

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.