Returns a text representation of a number rounded to the specified number of decimal places
The FIXED Function is categorized under Excel TEXT functions. It will provide a text representation of a number rounded to the specified number of decimal places.
While doing financial analysis, we often import data from external sources. The FIXED function helps convert numbers into text.
=FIXED(number, [decimals], [no_commas])
The FIXED function uses the following arguments:
If the [no_commas] argument is omitted, it uses the default value of FALSE.
As a worksheet function, FIXED can be entered as part of a formula in a cell of a worksheet. To understand the uses of the function, let us consider an example:
When we provide the following data using the FIXED function, let us see the result we would get:
The results in Excel are shown below:
Click here to download the sample Excel file
Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources: