Text
All versions
◉ 27 views
=FIXED()
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.
Applies To:
Excel for Microsoft 365Excel for Microsoft 365 for MacExcel 2024Excel 2024 for MacExcel 2021Excel 2021 for MacExcel 2019Excel 2016
=FIXED(number, [decimals], [no_commas])
Hover argument names in the table for details.
Output typeText
Popularity39 / 100
VolatileNo
Dynamic ArrayNo
📥 Download sample .xlsx ▦ Try in Playground
Dedicated file for this function — safe & lightweight · sample data + live formulas
⬇ Download Sample Workbook
A dedicated .xlsx for =FIXED() with Persian sample data & live formulas — open in Excel and practice.
- Sheet “Sample” — data table + formula in place
- Sheet “Guide” — syntax, arguments & tips from this page
- Instant & secure (token + rate limit)
🧠 🧠 Quiz this function
%d questions — syntax, example & errors — test yourself!
◧ Arguments
| Argument | Type | Required | Description |
|---|---|---|---|
number |
Number | Required | The number you want to round and convert to text. |
decimals |
Number | Optional | The number of digits to the right of the decimal point. |
no_commas |
Logical | Optional | A logical value that, if TRUE, prevents FIXED from including commas in the returned text. |
▣ Examples
▦ Data
| Cell | Value |
|---|---|
A2 |
1234.567 |
A3 |
-1234.567 |
A4 |
44.332 |
A5 |
1234.567 |
A6 |
-1234.567 |
A7 |
44.332 |
Rounds the number in A2 one digit to the right of the decimal point.
=FIXED(A2, 1)
Result:
1,234.6
Rounds the number in A2 one digit to the left of the decimal point.
=FIXED(A2, -1)
Result:
1,230
Rounds the number in A3 one digit to the left of the decimal point, without commas (the TRUE argument).
=FIXED(A3, -1, TRUE)
Result:
-1230
Rounds the number in A4 two digits to the left of the decimal point.
=FIXED(A4)
Result:
44.33
§ Remarks
- 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.
✦ Tips
- 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.
💬 Comments & Q&A 0 approved
🔒 Your comment will be published after review.Share your thoughts — visible after admin approval
No comments yet — be the first!