Excel - Excel Fixed Function

Description

The Excel FIXED function rounds a supplied number to a specified number of decimal places and then converts this into text. 

The format of the function is : 

FIXED( number, [decimals], [no_commas] ) 

Where the arguments are as follows :

Fixed Function Examples

The spreadsheet below shows examples of use of the Excel Fixed Function. The spreadsheet on the left shows the format of the functions and the spreadsheet on the right shows the results.

Fixed Function Common Problem 

Common Problem 

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. 

If you want to be able to use the numbers in calculations, you may prefer to keep the values as numbers in Excel and just change the formatting into the required numeric format. To do this: 

• Right click with the mouse, on the cell to be formatted

• Select the Format Cells ... option and ensure the Number tab is selected

• Under the Category heading, select the option Number

• From the options that appear on the right, specify the details of the formatting required

• Click OK