Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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