The Excel Fixed function rounds a supplied number to a specified number of decimal places and then converts this into text.
The syntax of the function is:
Where the arguments are as follows:
|number||-||The number to be converted into a text string.|
In the spreadsheet below, the Excel Fixed Function is used to convert the number 5123.591 into text, rounded to different numbers of decimal places.
Note that, in cell A1 of the above spreadsheet, the [decimals] argument is omitted from the Fixed function, so the default value of 2 is used.
Further details of the Excel Fixed function are provided on the Microsoft Office website.
If you get an error from the Excel Fixed Function, this is likely to be the #VALUE! error:
|#VALUE!||-||Occurs any of the supplied arguments are non-numeric.|
Some users encounter the following problem when using the Excel Fixed function:
Once a number has been converted, using the Excel Fixed function, it is stored in Excel as text. Therefore, it cannot be used in numeric calculations.
The easiest way to do this is to select the Currency formatting button on the Excel ribbon. This is generally located in the 'Number' group, on the Home tab of the ribbon (see below):