How to Use the FIXED function to round and convert numbers
To round numbers and return the result as text, we will use the FIXED function. With the FIXED Function, we are able to round a number to a specified number of decimals and we can return the result as text with or without commas. Here is the syntax that is used for the FIXED function:
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 including commas when set to TRUE. If no_commas is FALSE or omitted, the returned text includes commas.
Here is how we will round the numbers and convert them to text at the same.
How to round and convert numbers to text
- In cells A2:A10 enter your values like shown in the example below or use your own.
- Select cells B2:B10 and type the following formula: =FIXED(A2,-1,FALSE).
- Press CTRL+Enter.
- Select cells C2:C10 and type the following formula: =FIXED(A2,-2,FALSE).
- Press CTRL+Enter.
This tip should work in Excel 97, 2000, 2003 and 2007. Please leave a comment if this has helped you. Thanks.
