Spread Formula Reference
Formula Functions / Functions T to Z / TEXT
In This Topic
    TEXT
    In This Topic

    This function formats a number and converts it to text.

    Syntax

    TEXT(value,text)

    Arguments

    The text argument requires a string. Value requires numeric data or a reference to a cell that contains numeric data.

    Data Types

    Returns string data.

    Examples

    TEXT(A1,"$0.00") gives the result $10.00if A1 contains 10

    Version Available

    This function is available in product version 5.0 or later.

    See Also

    CHAR | EXACT | Text Functions