How to Add or Remove Dollar Sign in Google Sheets ( Easy Guide )

In this tutorial, we will learn How to Add or Remove Dollar Sign in Google Sheets

When you have a financial dataset in Google Sheets which represent the cost of an item it will need a currency format such as dollar Sign or other currency format which makes it better to understand.

To Add or Remove Dollar Sign in Google Sheets

• Select the cells where you want to add the dollar sign($)
• Below the Main Menu toolbar, select the Format as currency symbol shown with Dollar sign $.
• All the Selected cells with numbers will now have a dollar Sign as shown below.

To Remove Dollar Sign in Google Sheets

• Select the cells where you want to remove the dollar sign($)
• Click on the Format Menu on the Main menu bar
• Under Format Menu drop-down ,Select Number.
• Under Number drop-down ,Click on Number option

Let’s go the steps to Add or Remove Dollar Sign in Google Sheets in detail.

How to Add or Remove Dollar Sign in Google Sheets: Step by Step Guide

How to Add Dollar Sign in Google Sheets

Method 1 : By Using Format as Currency

• You can quickly add a dollar sign in Google Sheets using Format as currency

• The easiest way to add a dollar sign to your cells in Google sheets is to use the Format as currency symbol shown as a dollar sign below the Main Menu toolbar

To add a dollar Sign using Format as Currency follow the below steps.

1. Select the cells where you want to add the dollar sign($)
2. Below the Main Menu toolbar, select the Format as currency symbol shown with Dollar sign $.
3. All the Selected cells with numbers will now have a dollar Sign as shown below.

Method 2 : By Using the Format Menu

Another way to add a dollar sign to the list of numbers in the cell is by using Format Menu.

1. Select the cells where you want to add the dollar sign($)
2. Click on the Format Menu on the Main menu bar
3. Under Format Menu drop-down ,Select Number.
4. Under Number Click on Currency as shown below.

This method will also provide the same result as the previous Method . All the numbers in the cells will have a dollar sign at the beginning of the number in currency format.

Method 3 : By Using Accounting Format

• You can also add a dollar sign in Google Sheet using the accounting format option.

To add a dollar Sign in Google Sheet using accounting format follow the below steps :

1. Select the cells where you want to add the dollar sign($)
2. Click on the Format Menu on the Main menu bar
3. Under Format Menu drop-down ,Select Number.
4. Under Number Click on Accounting as shown below.

The above method will convert the numbers in the cell into an accounting format by inserting a dollar sign at the start of the cell.

How to Remove Dollar Sign in Google Sheets

• You can easily remove the dollar Sign in Google Sheets with a few clicks.

The best approach is to convert the Cell number formating to Numbers without a dollar Sign.

Follow the below steps to remove the dollar sign by switching the number format.

1. Select the cells where you want to remove the dollar sign($)
2. Click on the Format Menu on the Main menu bar
3. Under Format Menu drop-down ,Select Number.
4. Under Number drop-down ,Click on Number option

How to change the default currency in google sheets

If your default currency Sign is not a dollar Sign ($) as shown below .You can change the default currency following the below steps.

Go to File menu in the Main menu and Click on Setttings.

File ->Settings

• Once you click on settings the Settings for Spreadsheet screen will pop-up.
• Under General Tab change the default locale to Unites states.

Now Click on save and reload .

You will now have dollar Sign ($) as the currency format.

We hope this tutorial on How to Add or Remove Dollar Sign in Google Sheets was helpful.

Related articles :

How To Transpose Data in Google Sheets

How to count non-empty cells in google sheets

How to Count Cells based on Color in Google Sheets

How to Get Absolute value in Google Sheets ( Easy Guide )