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