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.
- 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.
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.
- Select the cells where you want to add the dollar sign($)
- Click on the Format Menu on the Main menu bar
- Under Format Menu drop-down ,Select Number.
- 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 :
- Select the cells where you want to add the dollar sign($)
- Click on the Format Menu on the Main menu bar
- Under Format Menu drop-down ,Select Number.
- 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.
- 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
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
