FIXED
TheFIXED
function formats a number as text with a specified number of digits after the decimal point. It is commonly used to display monetary values or percentages. The function returns the formatted number as a text string.
 How to use
FIXED
formula?  Examples of using
FIXED
formula FIXED
formula not working? Similar formulas to
FIXED
Usage
Use the FIXED
formula with the syntax shown below, it has 1 required parameter and 2 optional parameters:
 number (required):
The number to be formatted as text.  number_of_places (optional):
The number of decimal places to display. If omitted, defaults to 2.  suppress_separator (optional):
A boolean value that determines whether to use a thousands separator. If true, the separator is not used. If omitted, defaults to false.
Examples
Here are a few example use cases that explain how to use theFIXED
formula in Google Sheets.
Formatting monetary values
The FIXED
function can be used to format monetary values with a specified number of decimal places, making them easier to read and compare.
Displaying percentages
The FIXED
function can also be used to display percentages with a specified number of decimal places, making them easier to interpret.
Formatting numeric codes
The FIXED
function can be used to format numeric codes, such as product IDs or phone numbers, with a specified number of decimal places.
Common Mistakes
FIXED
not working? Here are some common mistakes people make when using the FIXED
Google Sheets Formula:
Forgetting to specify the number of decimal places
If you omit the number_of_places
parameter, the FIXED
formula will use a default value of 2, which may not be what you want. Be sure to specify the number of decimal places you require.
Using the formula with nonnumeric values
The FIXED
formula can only be used with numeric values. If you try to use it with text or other nonnumeric data, you will get an error message.
Forgetting to include the number parameter
The FIXED
formula requires a number parameter to be specified. If you forget to include this parameter, you will get an error message.
Related Formulas
The following functions are similar to FIXED
or are often used with it in a formula:

ROUND
The
ROUND
formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If theplaces
parameter is not specified, the formula rounds to the nearest integer. 
TRUNC
The
TRUNC
formula returns a number truncated to a specific number of decimal places. It is commonly used to remove decimal places from a number without rounding. This formula is often used in financial calculations and data analysis where exact values are important. 
CEILING
The
CEILING
function returns a number rounded up to the nearest multiple of a specified factor. It is commonly used to round up prices to the nearest dollar or to adjust numbers to fit into specific increments. 
FLOOR
The FLOOR formula rounds a given number down to the nearest multiple of a specified factor. It is commonly used when dealing with financial data or when working with time values. The function takes a value and an optional factor as arguments and returns the rounded down value.
Learn More
You can learn more about the FIXED
Google Sheets function on Google Support.