September 17, 2021

# How to use the 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.

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

READ:  How to use the Excel SUBSTITUTE function #### Excel

View all posts by Excel →