Number patterns

Numbers, used in a template and originating from a field in a record set can be displayed using a custom pattern.
You can enter the pattern in an expression (see Format Helpers), or in the Helper Wizard or Text Script Wizard (see Using the Helper Wizard, Using the Text Script Wizard and Formatting variable data). Note that for this to work, in the DataMapper the field that contains the value must be set to Integer, Float, or Currency.

In the Script Editor, the pattern can be passed to a function of the formatter; see formatter. The custom pattern may consist of pattern characters (see below), a prefix and a suffix.

Note that strings need to be converted to a number before they can be formatted this way.

The repetition of pattern letters determines the exact presentation. For example, the pattern "00000" limits the number to 5 digits and adds leading zeros to any numbers that are not 5 digits long.

Pattern characters

Symbol	Location	Localized?	Meaning
0	Number	Text	Digit
#	Number	Year	Digit, zero shows as absent
.	Number	Year	Decimal separator or monetary decimal separator
-	Number	Month	Minus sign
,	Number	Number	Grouping separator
E	Number	Number	Separates mantissa and exponent in scientific notation. Need not be quoted in prefix or suffix.
;	Subpattern boundary	Number	Separates positive and negative subpatterns
%	Prefix or suffix	Number	Multiply by 100 and show as percentage
\u2030	Prefix or suffix	Number	Multiply by 1000 and show as per mille value
¤ (\u00A4)	Prefix or suffix	Number	Currency sign, replaced by currency symbol. If doubled, replaced by international currency symbol. If present in a pattern, the monetary decimal separator is used instead of the decimal separator.
'	Prefix or suffix	Text	Used to quote special characters in a prefix or suffix, for example, "'#'#" formats 123 to "#123". To create a single quote itself, use two in a row: "# o''clock".

Source: http://docs.oracle.com/javase/7/docs/api/java/text/DecimalFormat.html.