Google Sheets FIXED Function: Syntax, Examples & Tips

number:
The numeric value that you want to format as text.

number_of_places:
(Optional) The number of decimal places to display. If omitted, it defaults to 2.

suppress_separator:
(Optional) A boolean value that determines whether to suppress the thousands separator. If TRUE, the separator is not used; if FALSE or omitted, the separator is used.

What is a FIXED Google Sheets Formula?

The FIXED function in Google Sheets is a useful tool that allows you to format a number to a specified number of decimal places and convert it into text. This function is particularly helpful when you want to present numerical data in a more readable format without altering the original number.

In simpler terms, FIXED enables you to control how many decimal places are displayed for a number, making it easier to read and understand.

A Practical Example

Imagine you are working on a financial report that includes various monetary values:

Financial Data Table:

You want to display these amounts with two decimal places for clarity.

FIXED Formula

To achieve this, you would use the FIXED function as follows:

=FIXED(B2, 2, TRUE)

In this formula:

• B2 is the cell containing the amount you want to format.
• 2 specifies the number of decimal places you want to display.
• TRUE indicates that you want to include a comma as a thousands separator.

Result of the Formula

When you apply the FIXED formula to the Financial Data Table, the output would look like this:

As you can see, the amounts are now formatted to two decimal places, making them easier to read.

Why Use FIXED?

The FIXED function is beneficial because it allows you to present numerical data in a clean and professional manner. It helps to avoid confusion that may arise from excessive decimal places and enhances the overall readability of your reports. Additionally, since the output is text, it can be used in conjunction with other text functions for further formatting.

Key Takeaways:

• FIXED: A Google Sheets function that formats a number to a specified number of decimal places and converts it to text.
• Customizable: You can specify the number of decimal places and whether to include a thousands separator.
• Improves Readability: Helps present numerical data in a clearer and more professional format.
• Common Use Cases: Ideal for financial reports, data analysis, and any scenario where numerical clarity is essential.

The FIXED function is an essential tool for anyone working with numerical data in Google Sheets, providing a straightforward way to enhance the presentation of your data.

Happy spreadsheeting!