# Learn How to Use Microsoft Excel FIXED Function

Written by | 0 Comments | 718 Views

In this article, you will learn how to use the Microsoft Excel FIXED function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel FIXED function return value and syntax with the help of some examples.

Microsoft Excel FIXED Function

The main objective of the Microsoft Excel FIXED function is to format a number as text with fixed decimals. That means with the help of the FIXED function, you can able to convert a number to a text with a fixed number of decimals, rounding off as required. When you want to concentrate on the formatted number with other text, the FIXED function is very useful there. You should keep in mind that the TEXT function is more flexible, and you can apply many different formats with it compared to the FIXED function.

### FIXED Function Return Value

The return value is the number formatted as a text.

### FIXED Function Syntax

= FIXED(number, [decimals], [no-commas])

Where the arguments:

• number: This is the number which you want to format and round off.
• decimals: The number of decimals you want to use, default is 2 (Optional).
• no-commas: This will suppress commas, TRUE = no commas, FALSE = commas (Optional).

## How to Use Microsoft Excel FIXED Function?

As we know, with the help of the FIXED function, you can convert a number to a text with a fixed number of decimals, rounding off as required. The number of the decimals are provided as an argument; let's see in few examples below:

Example 1: = FIXED(1000) - This will return the value 1000.00.

Example 2: = FIXED(1000, 0) - This will return the value 1000.

Example 3: = FIXED(1000, 0, FALSE) - This will return the value 1000.