Reference
No results for 'undefined'
    Powered by Algolia

    FORMAT_NUMBER

    Converts a number into text according to a specified format.

    Syntax

    =FORMAT_NUMBER(number, format)

    Parameters

    1. number
      • Type: Any
      • Description: The number to format.
    2. format
      • Type: String
      • Description: The pattern by which to format the number, enclosed in quotation marks

    Returns

    • Type: String
    • Description: This function always returns text according to a specified format

    Example

    =FORMAT_NUMBER(1.234, "#.##")

    See Also

    Contents