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.

**Syntax**: =FIXED(number, [decimals], [no_commas])

The FIXED function syntax has the following arguments:

**Number**(Required): The number you want to round and convert to text.**Decimals**(Optional): The number of digits to the right of the decimal point.**No_commas**(Optional): A logical value that, if TRUE, prevents FIXED from including commas in the returned text.

**Example**: Let’s look at some Excel FIXED function examples and explore how to use the FIXED function as a worksheet function in Microsoft Excel:

**Syntax**: =FIXED(A2,B2,C2)

**Result**:

Based on the Excel spreadsheet above, the following FIXED examples would return:

**Syntax**: =FIXED(A3,B3,C3)**Result**: 245

**Syntax**: =FIXED(A4,B4,C4)**Result**: 245

**Syntax**: =FIXED(A5,B5,C5)**Result**: 125.000

**Syntax**: =FIXED(A6,B6,C6)**Result**: 245.25

Very easy to understand. Thanks

Glad it was helpful to you