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.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas