# Google Sheets DOLLAR Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/dollar-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 DOLLAR function formats a number as text in currency format, allowing customization of decimal places and currency symbols. ``` DOLLAR(number, [number_of_places]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the DOLLAR you need in plain EnglishGenerate Formula ## Parameters **`number`**:\ The numeric value that you want to convert to a dollar format. **`number_of_places`**:\ (Optional) The number of decimal places to display in the dollar format. If omitted, it defaults to 2 decimal places. ## What is a DOLLAR Function? The *DOLLAR* function in Google Sheets is a useful tool that converts a number into text formatted as currency. This function is particularly helpful when you want to display monetary values in a specific currency format, ensuring that your financial data is presented clearly and professionally. In simpler terms, the DOLLAR function allows you to format numbers as currency, making it easier to read and understand financial figures in your spreadsheets. ## A Practical Example Imagine you are managing a budget spreadsheet that includes various expenses: ### Expenses Table: | Item | Amount | | - | - | | Rent | 1200 | | Utilities | 300 | | Groceries | 150 | You want to display the amounts in a currency format for better clarity. ## DOLLAR Formula To achieve this, you would use the DOLLAR function as follows: ``` =DOLLAR(B2) ``` In this formula: - `B2` is the cell containing the amount you want to format as currency. ## Result of the Formula When you apply the DOLLAR formula to the Amount column, the output would look like this: | Item | Amount | | - | - | | Rent | $1,200.00 | | Utilities | $300.00 | | Groceries | $150.00 | As you can see, the amounts are now displayed in a clear currency format, making it easier to read. ## Why Use DOLLAR? The DOLLAR function is beneficial because it ensures that your financial data is presented in a standardized format. This not only enhances the readability of your spreadsheets but also helps in maintaining consistency across your financial reports. Additionally, it can be customized to display different currency symbols and decimal places as needed. ## Key Takeaways: - **DOLLAR**: A Google Sheets function that formats numbers as currency text. - **Clarity**: Enhances the readability of financial data in your spreadsheets. - **Customization**: Allows for different currency symbols and decimal places. - **Common Use Cases**: Ideal for budgeting, financial reporting, and any scenario where monetary values need to be displayed clearly. The DOLLAR function is an essential tool for anyone working with financial data in Google Sheets, providing a straightforward way to present monetary values effectively. Happy spreadsheeting! ## Example use case You have a budget table where Column A lists expenses and Column B lists amounts. Use the DOLLAR formula to format the amounts in Column B as currency, ensuring clear financial reporting and easy readability for stakeholders reviewing the budget. ## 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 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) - [How To Insert Checkbox In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-checkbox-in-google-sheets) - [How To Insert Multiple Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-insert-multiple-rows-in-google-sheets) - [How To Lock A Row In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-a-row-in-google-sheets) - [How To Lock Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-cells-in-google-sheets) - [How To Make A Copy Of An Google Sheets Sheet](https://betteranalyst.com/google-sheets/how-to-make-a-copy-of-an-google-sheets-sheet) - [How To Make A Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-graph-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.