Skip to content

  • About us
  • Home
  • Cloud
    • Azure
  • Courses
  • Software & Apps
    • Google Sheets
    • Google Docs
    • Web Hosting
      • Best Web Hosting Services 2021
  • PC Tips
    • Windows
      • 11 Best Windows Freeware (Download Sites 2021)
  • Reviews
    • Top Affiliate Programs 2021
  • Sitemap Html

  • 5 Best Photography Courses for Beginners 2021
  • About us
  • Affiliate Disclaimer
  • Azure
  • Best skillshare classes on Communication Skills 2021
  • Blog
    • Top Affiliate Programs 2021
  • Cloud
  • Contact Us
  • Coursera
  • Courses
  • Google Photos : End of free unlimited storage on June 1st, 2021
  • Google Sheets
  • Home
  • Office
  • PC Tips
  • Privacy Policy
  • Python Online Python ide , Python Compiler
  • Reviews
  • SIP Calculator
  • Sitemap Html
  • Skillshare
  • Templates
  • Terms of use
  • Tools
  • Web Hosting
  • Windows

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

Blog, Google Sheets / By addnewskills / February 22, 2022 February 24, 2022

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.
How to Add or Remove Dollar Sign in Google Sheets

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 )

Post navigation
← Previous Post
Next Post →

Copyright © 2023 | addnewskills.com

  • Privacy Policy
  • Terms of use
  • Affiliate Disclaimer