The Excel FIXED function converts a number to text with fixed number of decimals, rounding as needed. The FIXED function can be useful when you want to concatenate a formatted number with other text. Note: the TEXT function is more flexible and can apply many different number formats.
Format number as text with fixed decimals
Number formatted as text
=FIXED (number, [decimals], [no_commas])
number - The number to round and format.
decimals - [optional] Number of decimals to use. Default is 2.
Like the Number format available on the home tab of the ribbon, the FIXED function will round the number as needed when applying a given number of decimal places. The main difference between applying a number format and using FIXED is that the FIXED function converts the number to text, whereas a number format just changes the way a number is displayed.