Format number

Merges a number written the way you want it: as currency, with thousands separators, or padded to a fixed width. Use it to make an order total or an invoice number read properly.

Syntax

{{formatNumber data format culture}}

Parameters

Name	Type	Required	Description
Data	Text or Number	Required	The value to format.
Format	Text	Optional	How the number is written, such as C for currency. Your account's default number format is used when you leave it out.
Culture	Text	Optional	The culture used for the currency symbol and separators, such as pt-BR. Your account's default is used when you leave it out.

For formats, see the standard numeric formats and the custom numeric formats.

Note: The currency format C takes its symbol from the culture, not from your account's billing currency. Supply a culture when you need a particular symbol.

Note: This changes how the number reads, it does not round it. To change the value itself, use Round, Round up or Round down.

Examples

The examples below are based on the following sample content:

Order total: {{formatNumber Contact.orderAmt "C"}}

A. The contact's orderAmt field has the value 1073.48 and a format of C

Order total: $1,073.48

B. The value is 973.48 and the format is US $#,000.0#

Order total: US $973.48

C. The value is 1059.38 and the format is 00000.0

Order total: 01059.4