The Excel FIXED Function

Basic Description

The Excel FIXED function rounds a supplied number to a specified number of decimal places and then converts this into text.

The syntax of the function is:

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

Where the arguments are:

number-The number to be converted into a text string.

An optional numeric argument that specifies the number of decimal places to be displayed after the decimal point.


  • If [decimals] is omitted, it takes on the default value of 2;
  • If [decimals] is negative, the supplied number is rounded up to the left of the decimal point.

An optional logical argument which specifies if the returned text should separate thousands by commas.

Possible values are:

TRUE-Commas are not included in the resulting text;
FALSE-Commas are included in the resulting text.
If the [no_commas] argument is omitted, it takes on the default value of FALSE.

Fixed Function Examples

The spreadsheets below show the Excel Fixed Function used to convert the number 5123.591 to text, rounded to different numbers of decimal places.

1=FIXED( 5123.591 )
2=FIXED( 5123.591, 1 )
3=FIXED( 5123.591, 0 )
4=FIXED( 5123.591, -1 )
5=FIXED( 5123.591, -2 )
6=FIXED( 5123.591, -3, TRUE )

Note that, in cell A1 of the above spreadsheet, the [decimals] argument is omitted from the Fixed function, so the default value of 2 is used.

Further details of the Excel Fixed function are provided on the Microsoft Office website.

Fixed Function Error

If you get an error from the Excel Fixed Function, this is likely to be the #VALUE! error:

Common Error
#VALUE!-Occurs any of the supplied arguments are non-numeric.

Fixed Function Common Problem

Some users encounter the following problem when using the Excel Fixed function:

Common Problem:

Once a number has been converted, using the Excel Fixed function, it is stored in Excel as text. Therefore, it cannot be used in numeric calculations.


If you want to be able to use your currency values in calculations, you should not use the Excel Fixed function. Instead, you should simply change the formatting of the original number into a currency format.

To do this:

  • Right click with the mouse, on the cell to be formatted;
  • Select the Format Cells ... option, to display the Format Cells dialog box;
  • Ensure the Number tab of the Format Cells dialog box is selected;
  • Under the Category heading, select the option Currency;
  • From the options that appear on the right, specify the details of the formatting required;
  • Click OK.

For further details of Excel Formatting, see the Excel formatting page.