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:

FIXED(1234567) results in 1,234,567.00
FIXED(1234567.555555,4,TRUE) results in 1234567.5556
FIXED(.555555,10) results in 0.5555550000
FIXED(1234567,-3) results in 1,235,000

end example]