# Excel FIXED Function

The Excel FIXED function converts a number to text with fixed number of decimals, rounding as needed. The FIXED function can be useful when you want to concatenate a formatted number with other text. Note: the TEXT function is more flexible and can apply many different number formats.

**number**- The number to round and format.**decimals**- [optional] Number of decimals to use. Default is 2.**no_commas**- [optional] Suppress commas. TRUE = no commas, FALSE = commas.

The FIXED function converts a number to text with fixed number of decimals. The number of decimals are provided as an argument. For example:

In the example shown, the formula in E6, copied down, is:

=FIXED(B6,C6,D6)

Like the Number format available on the home tab of the ribbon, the FIXED function will round the number as needed when applying a given number of decimal places. The main difference between applying a number format and using FIXED is that the FIXED function converts the number to text, whereas a number format just changes the way a number is displayed.

The FIXED function can be useful when you want to concatenate a formatted number with other text. However, the TEXT function is more flexible and can apply many different number formats.

## Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.