Mastering Google Sheets:Adding Dollar Signs in Formulas

Walter Jul 15, 2026

In the dynamic world of data management, Google Sheets has emerged as a powerful tool. It offers a wide range of features, including the ability to add monetary symbols like the dollar sign ($) to your cell formulas. This feature is particularly useful when dealing with currency values or financial data. Here's a step-by-step guide on how to add a dollar sign to a formula in Google Sheets.

How to Nest Multiple IF Statements in Google Sheets
How to Nest Multiple IF Statements in Google Sheets

With Google Sheets' user-friendly interface and robust functionality, formatting is made easy. Formatting is not just about aesthetics; it also aids in understanding and interpreting data. In the context of financial data, using the dollar sign can make your sheets clearer and more informative.

6 Crazy Google Sheets Formulas You Should Know
6 Crazy Google Sheets Formulas You Should Know

Understanding Formatting in Google Sheets

Before we dive into adding a dollar sign to a formula, it's crucial to understand the basics of formatting in Google Sheets. Formatting can involve several aspects, including numbers, text, and even images. For our purpose, we'll focus on number formatting, specifically the currency format.

How to Show Formulas in Google Sheets
How to Show Formulas in Google Sheets

Number formatting allows you to customize how numbers and currency are displayed. It's a powerful tool that can help ensure consistency and readability in your sheets, especially when working with financial data.

Accessing Number Formatting

How to add Formula in Google Sheet : Google Sheet Tutorial
How to add Formula in Google Sheet : Google Sheet Tutorial

To access number formatting in Google Sheets, you can either right-click on the cell or cells you want to format or use the Format menu. Here's how:

  1. Select the cell or cells you want to format.
  2. Right-click on the selection and choose "Format" from the context menu, then click on "Number."
  3. Alternatively, you can go to the "Format" menu at the top of your screen, then click on "Number."

Exploring Currency Formatting Options

Google Sheets
Google Sheets

Google Sheets provides several currency formatting options. These options include the currency symbol, decimal places, negative numbers, and more. Let's explore each:

  • Currency Symbol: This is where you'll find the dollar sign ($). You can choose from a variety of currencies or use a custom format.
  • Decimal Places: This allows you to set the number of decimal places you want to display.
  • Negative Numbers: Here, you can choose how to display negative numbers. Options include parentheses, red numbers, or no formatting.

Now that we've explored the basics of formatting in Google Sheets let's dive into adding a dollar sign to a formula.

How To Make A Budget On Google Sheets in 2026 (+ Examples)
How To Make A Budget On Google Sheets in 2026 (+ Examples)

Adding a Dollar Sign to a Formula

There are two primary ways to add a dollar sign to a formula in Google Sheets: using number formatting and using the TEXT function. Let's explore both methods.

the text reads,'get the sheet 100 + formulas'and an image of a
the text reads,'get the sheet 100 + formulas'and an image of a
How to Use the ArrayFormula Function in Google Sheets
How to Use the ArrayFormula Function in Google Sheets
How to use Google Sheets: A beginner's guide | Zapier
How to use Google Sheets: A beginner's guide | Zapier
Easily Calculate Stock Levels in Google Sheets with Simple Formulas – Step-by-Step Guide
Easily Calculate Stock Levels in Google Sheets with Simple Formulas – Step-by-Step Guide
Google Sheets: Creating Complex Formulas
Google Sheets: Creating Complex Formulas
How to Add and Sum in Google Sheets
How to Add and Sum in Google Sheets
Math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square
Math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square
How to Create a Pie Chart in Google Sheets: A Simple Step-by-Step Guide (With Example)"
How to Create a Pie Chart in Google Sheets: A Simple Step-by-Step Guide (With Example)"
How to Make a Budget in Google Sheets
How to Make a Budget in Google Sheets

Remember, the dollar sign in a formula serves a different purpose than in a cell. In a formula, it's used to anchor references to other cells. In this guide, we'll focus on adding the dollar sign for display purposes, i.e., in the cell itself.

Method 1: Using Number Formatting

As we've seen, Google Sheets provides a wide range of formatting options, including the currency symbol. Here's how to add a dollar sign using number formatting:

  1. Select the cell or cells where you want to add the dollar sign.
  2. Right-click on the selection and choose "Format," then click on "Number."
  3. In the sidebar that appears, under "Category," click on "Currency."
  4. Choose the appropriate currency from the dropdown menu, or click on "More Formats" for custom formatting.
  5. Click "Apply" or "OK" to save your changes.

Your selected cells should now display the currency symbol for the selected currency, including the dollar sign if you chose USD.

Method 2: Using the TEXT Function

The TEXT function in Google Sheets can help you format the appearance of a cell's content. It allows you to add a dollar sign to the beginning of text or numbers. Here's how to use it:

Let's say you have a cell containing a number, A1, and you want to display it as "$1,234.56". In another cell, B1, you can use the TEXT function like this:

=TEXT(A1, "$#,##0.00")

The "#,##0.00" is the formatting code. The dollar sign ($) adds the currency symbol, the "#" adds thousands separators (commas), and the "0.00" sets the number of decimal places. Change these as needed for your specific requirements.

Formatting is a powerful tool in Google Sheets. It not only makes your sheets more readable but also aids in data interpretation and communication. Whether you're working with financial data or not, understanding how to format your sheets can significantly improve your efficiency and accuracy.

Do you find yourself constantly adjusting formatting in your Google Sheets? Exploring shortcuts and keyboard commands can help streamline your workflow. Always remember that Google Sheets is a versatile tool that grows with you. The more you learn about it, the more proficient you'll become.

Happy formatting! And don't forget to share your tips and tricks with the community. We're always eager to learn and grow together.