FIXED

Round a number to decimal places with or without commas in Excel
Round number to decimal places with commas.

Rational

Round a number to decimal places with or without commas.

Description

The Excel FIXED function display a number in a text format after rounding the specified number of decimal places with or without commas.
For example, to round 1234.56789 to 2 digits after the decimal, use formula =FIXED(1234.56789,2,0), returns 1,234.57 (with two decimals).

Syntax

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

Parameters

number – Number to round
decimals [Optional] – Specify the decimal place to be rounded.
no_commas [Optional] – To display commas in the result.

Return Value

The boolean result (True or False)

Key Notes

  • In FIXED function default value of decimal is 2 places. Linking a blank cell in decimals argument is considered as a null value, and the return value will be with no decimals.
  • If no commas are required TRUE or 1 is an essential argument for the no_commas parameter of the FIXED formula otherwise FALSE or omitted (default) return the text including commas.
  • You can also use the Excel ROUND formula to execute the same functionality except for the comma specification.
  • In case of Negative value for the decimal argument, the return value will be in multiples. Example, with -2 and -3 as an argument, the return value of the number is rounded to closest multiple 100 and 1000 respectively and so on. In case the arguments exceed the value of a number, the return value will be ‘0’ (Zero).

Note: ROUND function return decimal position but in number format that can be part of Excel formula.

Keep Reading Similar Functions:

Convert number to currency (Dollar) in Excel

DOLLAR

The DOLLAR function display a number with a dollar currency. I.e. =DOLLAR(500) returns $500 as a currency but in a text format.

Read More »
Change the format of a number and converts it to text in Excel

TEXT

The TEXT function allows converting a value to a specific format based on the given format codes. E.g. =TEXT(31-12-2018,”MM/DD/YYYY”) return ” 12/31/2018″.

Read More »
Convert a text string without number format in Excel

VALUE

The VALUE function converts valid numbers with various number formatting (number, date, $ etc.) into a code number. E.g. “=VALUE(“31-12-2017”)” returns “43100”.

Read More »
Capitalizes the first letter of each word in Excel

PROPER

The PROPER function capitalizes the first letter of each word in a given alphabetical text. I.e., =PROPER(“michael jackson”) returns “Michael Jackson”.

Read More »
Converts number Thai currency Excel

BAHTTEXT

The Excel BAHTTEXT function converts a number to Thai currency with a suffix of “Baht”. I.e., to translate $5.50 in cell B7 =BAHTTEXT(B7) returns “ห้าบาทห้าสิบสตางค์”.

Read More »