FIXED

Syntax:

FIXED ( number [ , [ num-decimal ] [ , suppress-commas-flag ] ] )

Description: Produces a string containing number rounded to num-decimal decimal places. Thousands separator commas are included as determined by suppress-commas-flag.

Arguments:

Name	Type	Description
number	number	Designate the number that is to be formatted, truncated to integer.
num-decimal	number	Designate the number of decimal places to be used in the resulting string. If negative, number is rounded to the left of the decimal point. If omitted, a value of 2 shall be assumed.
suppress-commas-flag	logical	If `TRUE`, commas are not included; if `FALSE` or omitted, commas are included.

Return Type and Value: text – The string containing number rounded to num-decimal decimal places.

example: