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.
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.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.

Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course
Video training for Excel Tables