ID EN
…
#Text

FIXED

Excel Functions

Format number as text with fixed decimals

Syntax

EXCEL 
=FIXED(number, [decimals], [no_commas])

Arguments

Parameter Description
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. Default is FALSE.

Return Value

Number formatted as text

Details

The FIXED function converts a number to text, rounding to a given number of decimals. Like the Number format available on the home tab of the ribbon, the FIXED function will round the number as needed using the 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 takes three arguments, number, decimals, and no_commas. Number is the number to convert. Decimals is the number of digits to which number will be rounded on the right of the decimal point. If decimals is negative, number will be rounded to the left of the decimal point. Decimals is optional and defaults to 2. The no_commas argument is a Boolea

Examples

Examples

In the example shown above, the formula in E5, copied down, is:

EXCEL 
=FIXED(B5,C5,D5)
Examples

Number is the only required argument. By default, FIXED will round to 2 decimal places and insert commas for thousands:

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

The FIXED function can be useful when you want to concatenate a number with other text. The example below shows how the output from the PI function ca

EXCEL 
="PI is about "&PI() // returns "PI is about 3.14159265358979"
="PI is about "&FIXED(PI()) // returns "PI is about 3.14"

See Also

TEXT DOLLAR