Defining a custom number format

You can define a custom number format using special symbols to construct a format pattern. A format pattern shows where to place currency symbols, thousands separators, decimal points, or commas. Table 3-2 shows examples of custom format patterns and their effects on numeric data.

Table 3-2

Results of custom number formats

Format pattern	Data in the database	Result of formatting
0000.00	12.5 124.5 1240.553	0012.50 0124.50 1240.55
#.000	100 100.25 100.2567	100.000 100.250 100.257
$#,###	2000.00 20000.00	$2,000 $20,000
ID #	15	ID 15

Copyright Actuate Corporation 2012