In this article:

How to Remove the Dollar Sign in Google Sheets (2024 Update)

In this article, we will show you how to remove the dollar sign in Google Sheets. Simply follow the process below. 

How to Remove the Dollar Sign in Google Sheets using Custom Formatting 

Follow the steps below to easily remove the dollar signs in Google Sheets using custom formatting. 

1. Identify Cells with Dollar Signs for Formatting Adjustment

Locate the cells containing dollar signs you aim to eliminate. Click and drag to select multiple cells or use the Ctrl (Windows) or Command (Mac) key for individual non-adjacent cells. This removal process works only for dollar signs added through formatting.

how to remove dollar sign in google sheets

2. Access 'Format' Menu on the Top Menu Bar

Go to the top menu bar and select the "Format" option to unveil a dropdown menu. This menu provides a variety of formatting adjustments suitable for your selected data.

how to get rid of dollar sign in google sheets

3. Navigate to 'Number' Formatting Options

Look for the "Number" choice under the "Format" menu and hover or click to explore further. This section presents different numerical formatting options, including those without currency symbols.

how to remove the dollar sign in google sheets

4. Apply 'Plain Text' or 'Number' for Currency Symbol Removal

Within the "Number" section, pick "Plain Text" or "Number" for your highlighted cells. Choosing "Plain Text" converts the data into unformatted text, stripping away the currency symbol. Opting for "Number" changes the cell to a standard numeric format. 

5. Manually Remove Dollar Signs from Text Strings if Necessary

After reformatting, dollar signs applied via formatting should disappear. However, if the dollar sign is part of a text string rather than a formatting symbol, you'll need to edit the cells manually or use Google Sheets' "Find and replace" function to remove them. We explain this in more detail in the next section. 

How to Remove the Dollar Sign in Google Sheets using Find and Replace Method 

Follow the steps below to get rid of dollar signs ($) in Google Sheets using the find and replace method. 

1. Highlight Cells to Remove Dollar Signs From

Start by selecting the cells where you want to remove the dollar signs. You can click and drag to highlight multiple cells or click on a single cell if you need to change just one.

2. Access 'Find and Replace' from the Edit Menu

Go to the menu, click on "Edit," and then select "Find and replace." This opens a window where you can specify what you want to find and replace.

3. Enter Dollar Sign in 'Find' Field and Replace with Nothing

In the 'Find' field, enter the dollar sign ($). Leave the 'Replace with' field blank, directing Google Sheets to find all dollar signs and replace them with nothing. Click "Replace all."

Check if the dollar signs have been removed. Click 'Done.'

How to Get Rid of Dollar Signs in Google Sheets using a SUBSTITUTE Formula

Follow the steps below to remove dollar signs in Google Sheets using a formula. 

1. Create a New Column for Formula Output

Add a new column next to the one with the dollar values. This column will be used for the formula that removes the dollar signs.

2. Input SUBSTITUTE Formula to Replace Dollar Signs

Type the formula =SUBSTITUTE(A1, "$", "") in the first cell of the new column. Replace 'A1' with the cell reference of your data. This formula instructs Google Sheets to substitute the dollar sign in the specified cell with an empty string.

3. Extend the Formula to Other Cells by Dragging Down

Drag the formula down from the corner of the cell to apply it to the rest of the cells in the column.

We hope that you now have a better understanding of how to remove the dollar sign in Google Sheets. If you enjoyed this article, you might also like our article on how to switch the X and Y axis in Google Sheets or our article on how to subtract multiple cells in Google Sheets.

Automate everything you track in spreadsheets with Lido
Learn more

Automate manual tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Trigger
Action
Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
ADDCALENDAREVENT
Creates a one- or multiple-day calendar event with optional attendees
ADDHUBSPOT
Adds an object to Hubspot
ADDSLACKCHANNEL
Create a Slack channel, and optionally add a topic or members
CALLURL
Makes any HTTP request
CREATEGOOGLEDOC
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
CREATEPDF
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
FETCH
Makes any HTTP request and returns the response
INSERTROWS
Inserts given array below defined values in given worksheet
SENDGMAIL
Sends an email using your Google account
SENDOUTLOOK
Sends an email using your Microsoft Outlook account
SENDSLACK
Sends a Slack message
SENDSMS
Sends an SMS message using your Twilio account
UPDATECELL
Updates cells with given values
UPDATEHUBSPOT
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started