FORMATNUMBER

Formats a number in a given locale. This function is useful when including a number in a longer piece of text. To display just a number in a calculated field, it's recommended to set the display type of the calculated field to 'Number' and just return a number in the expression. When the display type of the calculated field is set to 'Number', the number is automatically displayed as a formatted number.

Parameters

value Number (required) - argument

language String (optional) [default = locale default] - the BCP 47 language identifier to use when formatting the number. e.g. en-US, fr-FR, en-AU or pt-BR

Returns

String - formatted number as text

Examples

FORMATNUMBER(1234.56789999)

// returns "1,234.568"
FORMATNUMBER(1234.56789999, 'fr-FR')

// returns "1 234,568"
FORMATNUMBER(1234.56789999, 'pt-BR')

// returns "1.234,568"

Did this page help you?