Microsoft Excel Functions & Formulas

Use the FIXED function to round and convert

numbers to text

To round numbers and return the result as text, use the FIXED

function. This function rounds a number to the specified number of

decimals, returning the result as text with or without commas.

FIXED(number, decimals, no_commas)

number: The number to round and convert to text.

decimals: The number of digits to the right of the decimal point.

If omitted, Excel sets it to 2.

no_commas: A logical value that prevents FIXED from includ-

ing commas when set to TRUE. If no_commas is FALSE or

omitted, the returned text includes commas.

4

To round and convert numbers to text:

1. In cells A2:A10, type values ...