Welcome to another tutorial from TeqTog! Hi there, so the topic for this tutorial will be how you can add and remove the dollar sign ($) in Google Sheets. I will be discussing the various steps involved and, by the time you have finished reading this article, you will know how easy it is to do it.
So, let’s begin!
Now, it is obvious why you might need to put the dollar sign in your spreadsheet. The dollar sign will represent your data as the currency so, therefore, anyone who views the information in your spreadsheet will understand that the figures you have shown are all monetary values.
Just like how you may need to put the dollar sign in front of the figures in your data; you may need to remove this sign as well.
You can learn to do both; from this tutorial.
1. Adding The Dollar Sign In Google Sheets
You can achieve this easily by formatting the cells in your spreadsheet into “currency”. I have used an example to show you how you can do this in detail:
- First of all, select the entire cell range which has your data and you want to show them beside dollar signs.
You can see that I have a set of data which I have highlighted by clicking on the top-left cell and dragging the cursor across over to the bottom-right cell.
- After selecting the cells, I will click on the “Format” option from the menu at the top of my spreadsheet.
- From the drop-down menu of “Format”, I will choose “Number”. A second drop-down menu will now appear and I will choose the option “Currency”. By doing this, my spreadsheet will display my figures as monetary values and put a dollar sign in front of them.
You can see that right in my example.
2. Adding The Dollar Sign: Shortcut
There is even a shortcut to putting the dollar sign.
- First, select the entire cell range as I have done earlier.
- Find the little dollar icon below the top menu bar of your spreadsheet and, click on it.
Your numbers should now have the dollar sign in front of them.
Lastly, there is also the option for you to format your rows to “Accounting”. This will too, convert your figures into monetary values and place a dollar sign at the beginning of them.
3. Putting The Dollar Sign: The Accounting Format
Here are the steps:
- Just like before, select all of your relevant cells.
- Go to the “Format” option from the top menu bar and click on it.
- From the drop-down menu, hover your cursor over the “Number” option.
- As you know already, a second drop-down will appear. From the options choose “Accounting”.
- Your spreadsheet will now place a dollar sign. However, you should note that the dollar signs will not be as near your figures; but at the very left of the cell. This sort of display will stay fixed.
How To Remove The Dollar Sign In Google Sheets
Now when it comes to removing the dollar sign; all you need to do is unformat all your cells. It doesn’t matter whether you used the “currency” format or the “accounting” format, you just need to format them back to regular numbers, and, this will remove the dollar sign.
- Select all your cells.
- Go to the “Format” menu
- Put your cursor on “Number” to open the second drop-down menu.
- Select “Number” to remove the $ sign.
If by any chance, the dollar signs were inserted manually, then this way of unformatting may not help. You need to use the “Find and Replace” function to find all of the dollar signs and replace them with nothing.
Well, I hope my article on how you can add or remove the dollar sign in Google Sheets was helpful for you.
Best of luck!
Read More Google Sheet Tutorial Articles: