Examples of numeric patterns

The following table shows some example display patterns and the results of formatting some example input values (user input or bound data) using the display pattern. The formatted results are delimited by double quotation marks so that you can see where spaces would appear in the result. The quotation marks are not part of the result. In these examples, the locale is English (USA).

Pattern

Input value

Formatted value

     

zzz,zz9.99

123456.1236

123456.4

123456

“123,456.12”

“123,456.40”

“123,456.00”

$Z,ZZ9.99

123.4

“ 123.40”

$z,zz9.99CR

1234

-1234

“$1,234.00”

“$1,234.00CR”

$Z,ZZ9.99DB

123

-123

“$ 123.00”

“$ 123.00DB”

($z,zz9.99)

1234

-1234

“ $1,234.56 “

“($1,234.00)”

zzz9

12.0

“12”

Szzz,zz9.99

1234.56

-1234.56

“1,234.56”

“-1,234.56”

$9,999.99

123.4

“$0,123.40”

$Z,999.99

123.4

“$ 123.40”

99999

1234

“01234”

S999v99

-1.23

"-00123"

S999V99

-1.23

123

"-001.23”

" 123.00"

SZZ9.99

12.3

-12.3

" 12.30"

"- 12.30"

szz9.99

12.3

-12.3

“12.3”

“-12.3”

99.999E

12345

0.12345

"12.345E+3"

"12.345E-2”

The table below shows the results of converting some example input values (user input or bound data) into raw values using an edit pattern or data pattern.

Custom pattern

Input value

Raw value

99V99

1050

3125

10.50

31.25

99.999E

12.345E3

12.345E-2

12345

0.12345

z999

150

0150

150

150

z,zz9.99

10.50

3,125.00

10.50

3125.00

$z,zz9.99DB

$1,234.00

$1,234.00DB

1234.00

-1234.00

// Ethnio survey code removed