FIXED Function. Round a number to the specified number of digits. Then converted to a comma-separated string.(Microsoft Excel)
The FIXED function converts a number to a comma-separated string.
If you just want to display it, cell formatting is sufficient.
However, the FIXED function is used when you want to combine it with other string manipulation functions.
Contents
How it works
=FIXED(Numbers,Decimals,No_conmmas)
Name | Omission | Explanation |
---|---|---|
Numbers | Required fields | Specify the number to be converted. |
Decimals | 2 | Specify the number of decimal places as a number. |
No_conmmas | FALSE | TRUE: No comma FALSE: 3-digit comma delimited |
Decimals
Value | Explanation |
---|---|
-2 | Hundreds place |
-1 | Tens place |
0 | Ones place |
1 | First decimal place |
2 | Second decimal place |
Demonstrate
Since the result is a string, it is initially left-aligned.
It is recommended to right-align the result since it is difficult to read as a number when displayed as it is.

Spill
If you specify range of cells in string, it will be a Spill.

---
Discussion
New Comments
No comments yet. Be the first one!