Last Updated on October 31, 2023 by Jake Sheridan
In this tutorial, you will learn how to add a dollar sign in Google Sheets.
How To Add Dollar Sign In Google Sheets
The dollar sign ($) is a commonly-used symbol in spreadsheets containing financial data. It is often used to indicate a currency.
In Google Sheets, you can quickly add a dollar sign to a value by using the built-in formatting options. In this guide, we will show you how to add a dollar sign in Google Sheets. We will also explain the difference between different number formatting options such as the Accounting format and the Currency format.
How To Insert a Dollar Symbol In Google Sheets
Here’s how to insert a dollar symbol in Google Sheets.
First, select the range you want to add a dollar sign to.
In the example above, we’ll use the range A2:A14 which contains a list of transaction amounts.
In the Google Sheets toolbar, click on the dollar sign symbol to format the range as currency.
Your range should now have a dollar sign added before the number itself.
Since most currencies handle denominations up to the hundredths place, Google Sheets formats the numbers as decimals.
Alternatively, users can use the Format menu to add a dollar sign. Click on Format > Number to find a list of number formatting options.
The Accounting format will align the dollar sign to the left of the cell and the numerical section to the right of the cell. Negative numbers will be enclosed in parentheses.
To remove the dollar sign in Google Sheets, simply select the desired range and click on Format > Number > Number.
The range should now revert back to a basic number formatting without any currency symbols.
This guide should be everything you need to add a dollar sign in Google Sheets. You may make a copy of this example spreadsheet to test it out on your own.
More ways to clean data in Google Sheets:
- Clear Cells
- Clear Contents
- Clear Formatting
- Clear Filter
- Stop Google Sheets From Rounding
- Remove Dollar Sign
- Stop Google Sheets From Deleting Zeros
- Separate First And Last Name
- Format Phone Numbers
- Change Currency
- Split Text To Columns
- Split Text to Rows
- Split Cells
- Split Text
- Find And Replace
- Find And Replace Wildcard
- Swap Cells
- Check if a Cell is Not Empty