FIXED

Converts a number to text with a fixed decimal place.

Syntax

FIXED(number,{decimals},{no-commas})

Arguments

number	Number or cell reference to convert.
decimals	Number of decimal places.  The default is 2.
no-commas	If set to TRUE, commas are omitted from the number. Otherwise, the number displays commas.

Examples

FIXED(10000) returns 10,000.00
FIXED(1000,3,TRUE) returns 1000.000