In this article:

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

May 8, 2024

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.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->