Format numbers as text with fixed decimals.

`=FIXED(number, [decimals], [no_commas])`

- number - required
- decimals - [OPTIONAL]
- no_commas - [OPTIONAL]

`=FIXED(A2, 1)`

This example, rounds the number in A2 one digit to the right of the decimal point, returning 1.234.6.

`=FIXED(A2, -1)`

The Sourcetable function FIXED can also round a given number to the left of the decimal point. For example, this rounds A2 one digit to the left of the decimal point, returning 1.23.

`=FIXED(A3, -1, TRUE)`

The Sourcetable function FIXED can also be used with the TRUE argument to round a negative number to the left of the decimal point. For example, this rounds A3 one digit to the left of the decimal point and returns -1230.

`=FIXED(A4)`

The Sourcetable function FIXED can also be used without the argument. This example rounds A4 two digits to the left of the decimal point, returning 44.33.

The FIXED function rounds a number to a specified number of digits and formats it as text with commas and a period. The output is always in decimal format.

- The FIXED function is useful for formatting numbers as text and returning text rather than a number.
- The FIXED function rounds to the given number of digits and can be used to concatenate text with numbers.
- The FIXED function can be used to format numbers and retain their numeric properties.

The FIXED function is a numerical function that rounds numbers to the specified number of decimal places. This function is one of Sourcetable's rounding functions and is used to display a number in a fixed-decimal format.

The FIXED function requires two arguments:

- Number: This argument is required and must be in decimal format.
- Decimals: This argument is optional and determines the number of decimal places that the returned value should have.
- No_commas: This argument is optional. If it is set to TRUE, commas will not be included in the returned value.

The FIXED function returns a text value as the result. The result is rounded to the left of the decimal point.

Drop CSV