Exceljet

Quick, clean, and to the point

Excel FIXED Function

Excel FIXED function
Summary 

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.

Purpose 
Format number as text with fixed decimals
Return value 
Number formatted as text
Syntax 
=FIXED (number, [decimals], [no_commas])
Arguments 
  • 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.
Version 
Usage notes 

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

=FIXED(1000) // returns "1,000.00"
=FIXED(1000,0) // returns "1,000"
=FIXED(1000,0,FALSE) // returns "1000"

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 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.