This article describes the formula syntax and usage of the FIXED function (function: A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.) in Microsoft Excel.
Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.
FIXED(number, [decimals], [no_commas])
The FIXED function syntax has the following arguments (argument: A value that provides information to an action, an event, a method, a property, a function, or a procedure.):
- Number Required. The number you want to round and convert to text.
- Decimals Optional. The number of digits to the right of the decimal point.
- No_commas Optional. A logical value that, if TRUE, prevents FIXED from including commas in the returned text.
- Numbers in Microsoft Excel can never have more than 15 significant digits, but decimals can be as large as 127.
- If decimals is negative, number is rounded to the left of the decimal point.
- If you omit decimals, it is assumed to be 2.
- If no_commas is FALSE or omitted, then the returned text includes commas as usual.
- The major difference between formatting a cell containing a number by using a command (On the Home tab, in the Number group, click the arrow next to Number, and then click Number.) and formatting a number directly with the FIXED function is that FIXED converts its result to text. A number formatted with the Cells command is still a number.
The example may be easier to understand if you copy it to a blank worksheet.
How do I copy an example?
- Select the example in this article. If you are copying the example in Excel Online, copy and paste one cell at a time.
Important: Do not select the row or column headers.
Selecting an example from Help
- Press CTRL+C.
- Create a blank workbook or worksheet.
- In the worksheet, select cell A1, and press CTRL+V. If you are working in Excel Online, repeat copying and pasting for each cell in the example.
Important: For the example to work properly, you must paste it into cell A1 of the worksheet.
- To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
After you copy the example to a blank worksheet, you can adapt it to suit your needs.
||Rounds the first number 1 digit to the right of the decimal point (1,234.6)
||Rounds the first number 1 digit to the left of the decimal point (1,230)
|=FIXED(-1234.567, -1, TRUE)
||Rounds the second number 1 digit to the left of the decimal point, without commas (-1230)
||Rounds the third number 2 digits to the left of the decimal point (44.33)