Home Search

DriveWorks Pro 22
Fixed

Send Feedback

Fixed

Returns a number as text, to a fixed number of decimal places.

Thousand separators (commas) can optionally be included.

Syntax

Fixed([Number], [DecimalPlaces], [NoCommas])

Where:

Number is the number to round.

Decimal places is the number of decimal places to return.

NoCommas is either 0 (zero) or 1, 0 being include commas, 1 exclude commas.

Examples

Rule

Meaning
Fixed(1124.03, 1, 1)The function rounds the number 1124.03 to the defined number of decimal places (in this case; 1) and then removes all commas from the result. The result in this case is 1124.0.

Example Outcomes

NumberDecimalPlacesNoCommasOutcome
11940.7322011,940.73
9468.257219468.26