$FNumber()

Examples of $FNUMBER()

The $FNUMBER function returns a string containing a formatted number.

The format for the $FNUMBER function is:

    $FN[UMBER](numexpr,expr[,intexpr])
    

$FNUMBER() formats or edits numbers, usually for reporting. For more information on rounding performed by $FNUMBER(), refer to the section on $JUSTIFY().

The formatting codes are:

+: Forces a "+" on positive values.

-: Suppresses the "-" on negative values.

,: Inserts commas every third position to the left of the decimal within the number.

T: Represents the number with a trailing, rather than a leading sign; positive numbers have a trailing space unless the expression includes a plus sign (+).

P: Represents negative values in parentheses, positive values with a space on either side; combining with any other code except comma (,) causes a run-time error.

M: accepts both lower-case and upper-case alphabetic codes. The order of the codes does not affect the result.