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.
value Number (required) - argument
language String (optional) [default = locale default] - the BCP 47 language identifier to use when formatting the number. e.g.
String - formatted number as text
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"
Updated over 1 year ago