Site icon Kaizen.Personal computer work.

FIXED Function. Round a number to the specified number of digits. Then converted to a comma-separated string.(Microsoft Excel)

Japanese version.

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)
NameOmissionExplanation
NumbersRequired fieldsSpecify the number to be converted.
Decimals2Specify the number of decimal places as a number.
No_conmmasFALSETRUE: No comma
FALSE: 3-digit comma delimited

Decimals

ValueExplanation
-2Hundreds place
-1Tens place
0Ones place
1First decimal place
2Second 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.

---

Links

Microsoft Excel Functions Text

Exit mobile version