In this article, we will show you how to remove the dollar sign in Google Sheets. Simply follow the process below.
Follow the steps below to easily remove the dollar signs in Google Sheets using custom formatting.
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.
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.
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.
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.
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.
Follow the steps below to get rid of dollar signs ($) in Google Sheets using the find and replace method.
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.
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.
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.'
Follow the steps below to remove dollar signs in Google Sheets using a formula.
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.
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.
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.
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.