Formatting Functions

Format Numbers, Currency, Phone Numbers
  • FORMATNUMBER

    Format a number with grouped thousands

    FORMATNUMBER(1234.56)
    Try this example
    number (number)
    The number being formatted.
    decimals (string)
    Optional: Sets the number of decimal points.
  • FORMAT_CURRENCY

    Transforms a number to a specified currency

    FORMAT_CURRENCY(12345.67,"EUR","en_GB",",")
    Try this example
    number (number)
    The number to convert as currency
    currency (string)
    Currency code
  • FORMAT_PHONE_NUMBER

    Transforms a phone number to a specified style

    FORMAT_PHONE_NUMBER("12223330044","US","INTL")
    Try this example
    string (any)
    The phone number to convert as phone number
    country (string)
    Country code