# Google Sheets FIXED Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/fixed-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The FIXED function formats a number to a specified number of decimal places and returns it as text, optionally including or excluding commas. ``` FIXED(number, [number_of_places], [suppress_separator]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the FIXED you need in plain EnglishGenerate Formula ## Parameters **`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: | Item | Amount | | - | - | | Revenue | 12345.6789 | | Expenses | 9876.5432 | | Profit | 2469.1357 | 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: | Item | Amount | Formatted Amount | | - | - | - | | Revenue | 12345.6789 | 12,345.68 | | Expenses | 9876.5432 | 9,876.54 | | Profit | 2469.1357 | 2,469.14 | 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! ## Example use case You have a sales report in Column A with total sales figures. Use the FIXED formula to format these numbers to two decimal places, ensuring consistency and clarity in your financial presentations. This enhances readability for stakeholders reviewing the report. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Divide In Google Sheets](https://betteranalyst.com/google-sheets/how-to-divide-in-google-sheets) - [How To Enable Macros In Google Sheets](https://betteranalyst.com/google-sheets/how-to-enable-macros-in-google-sheets) - [How To Filter In Google Sheets](https://betteranalyst.com/google-sheets/how-to-filter-in-google-sheets) - [How To Find Circular References In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-circular-references-in-google-sheets) - [How To Find Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-find-duplicates-in-google-sheets) - [How To Freeze A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-a-row-in-google-sheets) - [How To Freeze Panes In Google Sheets](https://betteranalyst.com/google-sheets/how-to-freeze-panes-in-google-sheets) - [How To Highlight Duplicates In Google Sheets](https://betteranalyst.com/google-sheets/how-to-highlight-duplicates-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.