FIXED Function in Excel: Syntax, Examples and Free Practice
FIXED is an Excel Text function. Rounds a number and converts it to text with a fixed number of decimals.
FIXED syntax
Arguments
number: A number to use in the calculationdecimals: How many decimal places to use (optional)no_commas: Whether to leave out thousands separators (optional)
When to use FIXED
FIXED is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice FIXED online, free
Open the live Excel-style spreadsheet and try FIXED yourself. No Excel install or sign-up needed to start.
Practice FIXED now →More Text functions
Frequently asked questions
What does the FIXED function do in Excel?
Rounds a number and converts it to text with a fixed number of decimals.
What is the syntax of FIXED in Excel?
The syntax is =FIXED(number, [decimals], [no_commas]). number: A number to use in the calculation; decimals: How many decimal places to use (optional); no_commas: Whether to leave out thousands separators (optional).
Where can I practice FIXED online for free?
Open the free live spreadsheet on Cellgrids and try FIXED yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts