Formulas > =FIXED()
How to Use FIXED() in Google Sheets
Description
How To Actually Use FIXED() in Sheets
FIXED(number, [number_of_places], [suppress_separator])
Try FIXED yourself
In cell B1, use the FIXED formula to format the number in cell A1 to 2 decimal places. The result should be a text string with exactly two decimals.
Hints (2)
-
Remember to specify the number of decimal places.
-
The result should be a text format, not a number.
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 BetterSheets.co/formulas
Learn more about the FIXED() formula:
Generate a FIXED() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses FIXED(). 2 free AI generations, no signup. Members get unlimited use.
Generate a FIXED() formula