# 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.

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.