FIXED

FIXED —

FIXED(num,[decimals, no_commas])

FIXED returns num as a formatted string with decimals numbers after the decimal point, omitting commas if requested by no_commas.

This function is Excel compatible.

FIXED(1234.567,2) equals "1,234.57".

TEXT, VALUE, DOLLAR.