Google Sheets DOLLAR Function: Syntax, Examples & Tips

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:

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:

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!