FIXED Function

The FIXED function is used to convert the given number to text.
Note: The numbers, while converting into text, can be rounded to specific decimal places. Commas can also be inserted.

Formula:


=FIXED (Number, Decimal Place, No Commas)
No Commas - if the value is TRUE, then commas will not be inserted; if the value is FALSE, then the commas will be inserted.
Also for decimal place if the value is not mentioned, it takes two places by default.

Video Tutorial:


Let us convert the given numbers to text, using the FIXED function, with the help of the below video

Learn MS Excel


Ask Questions

Ask Question