Formatting Numbers in Form Letters and Emails

Share this article:

To format number fields in form letter and emails, use syntax similar to the following: {Invoice.Balance(<format>)} where <format> is similar to one of the following:


Format Description Syntax Example Result  for "1234.567"
0 Show the number as an integer {Invoice.Balance(0)} 1235
0.0 Show the number as a floating point number with one decimal place {Invoice.Balance(0.0}) 1234.5
0.00 Show the number as a floating point number with two decimal places {Invoice.Balance(0.00}) 1234.57
00000.0 Show the number with at least 5 digits and one decimal place (prefixed with 0) {Invoice.Balance(00000.0}) 01234.6
#,##0.0 Show the number with at least 1 digit and one decimal place, with commas separating thousands. {Invoice.Balance(#,##0.0}) 1,234.6