Formulas > =FIXED()

How To Use FIXED() Function in Google Sheets


Formats a number with a fixed number of decimal places.

Common questions about the FIXED formula include:
• How do I use FIXED formula? 
• What kinds of calculations does the FIXED formula do?
• What arguments can I use inside the formula?

The FIXED formula can be used to round numbers to a specific number of decimal places and/or return a specific number of characters from the left or right side of an original string.

The FIXED formula can be commonly mistyped by forgetting the closing parenthesis, or using incorrect arguments.

Some common ways the FIXED formula is used inappropriately include using it to round numbers to a specific number of significant digits, rather than a specific number of decimal places; or trying to extract data outside of the length of the original string.

Some common pitfalls when using the FIXED formula include forgetting to include the desirable number of decimal places and characters as arguments within the formula, or underestimating the amount of characters used in a document which results in inaccurate data extraction.

Common mistakes when using the FIXED Formula include not specifying the decimal places you would like the result to be rounded up to, or not understanding the syntax for using the formula.

Common misconceptions people might have with the FIXED Formula include thinking it can be used to combine strings, that it can be used to round number to a specific number of significant digits, or that it can be used to extract data from outside the length of the original string.

How To Actually Use FIXED() in Sheets

FIXED(number, [number_of_places], [suppress_separator])

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the FIXED() formula:

3.4 GoogleSheets Tutorial | Fix Decimal Places in Number using Fixed Function in Google Sheets

In this video learn how to manage or fix decimal places or thousand separator in any number using "Fixed Function" in Google Sheets

Generate a FIXED() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.