Investment Studio > Expressions > Functions > Text > FIXED

string fixed(float value, integer digits = 2, boolean no_commas = FALSE)

Returns the string representation of value rounded to the specified number of digits and formatted using the system-defined thousands and decimal separator characters (see the Regional Settings applet in the Windows Control Panel).

If digits >= 0, value is rounded to digits decimal places.

If digits < 0, value is rounded digits places left of the decimal point.

If digits is omitted, it defaults to 2.

If no_commas is TRUE, the thousands separator character is not used.

If no_commas is omitted, it defaults to FALSE.

Examples

Assuming default US number format settings,

=fixed(7654.321, 2)

equals "7,654.32"

=fixed(7654.321, -2, TRUE)

equals "7700"

=fixed(-7654.321, -2)

equals "-7,700"

=fixed(-0.765, 4)

equals "-0.7650"

=fixed(67.788)

equals "67.79".

See also dollar, round, value.