Defining a custom number format

You can define a custom number format using special symbols to construct a format pattern. A format pattern shows places held by the currency symbol and the thousands and decimal separators. The thousands separator and the decimal separator are locale-dependent. In the US (English) locale, for example, a comma separates thousands places, and a period separates decimal places. In most European locales, a space separates thousands places, and a comma separates decimal places. Table 2-2 lists example results of custom number format patterns.

Table 2-2

Results of custom number formats

Format pattern	Data in original format	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 OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2