Related Functions:

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

Syntax

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

Arguments

Argument Description
number The number to be converted into a text string
[decimals] Optional. The number of digits to the right of 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
  If [decimals] is a decimal,rather than an integer, it is truncated to an integer
[no_commas] Optional. A 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.

Examples

  A B C D
1 Number Function Result Notes
2   =FIXED(124.567) 124.56 If [decimals] is omitted, it takes on the default value of 2
3 124.567 =FIXED(A2) 124.56 If [decimals] is omitted, it takes on the default value of 2
4   =FIXED(A2,1) 124.5  
5   =FIXED(A2,0) 124  
6   =FIXED(A2,-1) 120  
7   =FIXED(A2,-2) 100  

Common Function Error(s)

Problem What went wrong
Result cannot be used in calculations Once a number has been converted, using the FIXED function, it is stored in Excel as text and cannot be used in numeric calculations

  If you want to be able to use the numbers in calculations, you may prefer to keep the values as numbers in Excel and just change the cell formatting into a numeric format