FIXED Function in Excel

FIXED Function in Excel rounds the supplied number to a specified number of decimal places and converts them into text format.

Syntax of FIXED Function in Excel:

Where,

• number – The number to be converted into text format.
• [decimal] – An optional argument that specifies the number of decimal places to be rounded off. If omitted, it takes default value as 2 and rounds off to 2 decimal places.
• [no_commas] – An optional logical argument that specifies if the value should be separated by commas.
  • TRUE – Commas are not included in the resulting text;
  • FALSE – Commas are included in the text.

Default value is FALSE, so if omitted Commas are included by default.

Example of FIXED Function in Excel:

Formula:

• In the first two examples [no_commas] argument is not passed to the Fixed Function so the comma will occur in the resulting text
• In the last example [no_commas] argument is TRUE so the commas does not occur in the resulting text

So the result will be

Result:

Note: #VALUE! Error occurs if either of the supplied arguments are non-numeric.