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 including commas when set to TRUE. If no_commas is FALSE or omitted, the returned text includes commas.
1. In cells A2:A10, type values with decimals.
2. Select cells B2:B10 and type the following formula: =FIXED(A2,-1,FALSE).
3. Press <-Ctrl+Enter->.
4. Select cells C2:C10 and type the following formula: =FIXED(A2,-2,FALSE).
5. Press
Watch the Video Tutorial - https://www.youtube.com/watch?v=zXyDrUoA3rE
Hope You Like This Tutorial - Give Comments
