The FIXED function returns numbers as text with the specified number of decimals.
Formula:
=FIXED(number, [decimals], [no_commas])
Explanations:
The Number is required, the number that you need to convert to text with rounded decimals;
[decimals] is optional, the number of decimals you need to round.
– When it is positive, the number is rounded to the right of the decimal point.
– When it is negative, the number is rounded to the left of the decimal point.
– When it is omitted, the default number of decimals is 2.
[no_commas] is optional.
– When it is false or omitted, the rounded text includes a comma as a separator.
– When it is true, the rounded text will not include a comma as a separator.
Cautions:
The major difference between the FIXED function and the command on the Home tab is that the Fixed function converts a number to text, while numbers formatted with Cell command are still numbers.
Example 1: When [decimals] is positive, the number is rounded to the right of the decimal point.
= FIXED(A2,1)
Number 79525.562 is rounded to 79,525.6 with one digit on the right of the decimal point.
Example 2: When [decimals] is negative, the number is rounded to left of the decimal point.
= FIXED(A3,-1)
Number 79525.562 is rounded to 79,530, one digit to the left of the decimal point.
Example 3: When [no_commas] is FALSE or omitted, the returned text includes commas; when it s true, the returned text does not include comma.
= FIXED(A4, -1, TRUE)
When [no_comma] is true, the returned text does not include a comma, so number 79525.562 is rounded to 79530.
Example 4: When [decimals] is omitted, the default number of decimals is 2.
= FIXED(A5)
When [decimals] is omitted, the default number of decimals is 2, so the number 79525.562 is rounded to 79525.56.