Change Numbers to Text With Excel FIXED Function

http://www.contextures.com/30excelfunctionsin30days30xl30d.html Use the FIXED function in Excel to round a number and return the result as text.

The FIXED function can round a number to a set number of decimal places, and show the result as text, with or without comma separators.

In most cases, another function, such as ROUND or TEXT, or simply changing the cell's number format, would be a better choice.

Watch this video to see how to use the Excel FIXED function, and return a rounded number as text.

Category:

Science & Technology

Tags:

• Excel FIXED function
• Excel FIXED
• Excel FIXED formula
• Excel round
• Excel version
• Excel
• FIXED function
• Contextures