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