Spread WinRT Documentation
Spread WinRT Documentation / Formula Reference / Formula Functions / FIXED
In This Topic
    FIXED
    In This Topic

    Summary

    This function rounds a number to the specified number of decimal places, formats the number in decimal format using a period and commas (if so specified), and returns the result as text.

    Syntax

    FIXED(num,digits,notcomma)

    Arguments

    This function has these arguments:

    Argument Description
    num Number to round and convert to text
    digits [Optional] Number of decimal places; if omitted, uses two places
    notcomma [Optional] Logical value whether not to use commas; if omitted or FALSE, returns with commas

    Data Types

    Accepts numeric data for first two arguments; accepts logical value for the third argument. Returns string (text) data.

    Examples

    FIXED(B3)

    FIXED(R3C2,2,FALSE)

    FIXED(4.2365,3)

    See Also