Properly formatting values in a spreadsheet is an important consideration in making the data easy to interpret for your readers. In the case of monetary values, using a standardized format, specifically one that will always use two decimal places, makes it easier to evaluate a lot of numerical values in a column.
But the Google Sheets currency formatting will place a dollar symbol in front of your cell values, which may not be something that you want. Our guide below will show you how to change this formatting so that you keep the two decimal places, but lose the dollar sign.
How to Format Currency Without a Dollar Symbol in Google Sheets
The steps in this guide are performed in the Web browser version of Google Sheets. These steps assume that you are seeing dollar symbols in your cells as the result of a formatting setting that is currently applied. If the dollar symbol is actually a part of the text contained within the cell, rather than the result of formatting, then you may need to manually delete those characters.
Step 1: Go to Google Drive at https://drive.google.com/drive/my-drive and open the spreadsheet file that you wish to reformat.
Step 2: Select the cells containing the dollar symbol formatting that you want to remove.
Step 3: Click the More formats button in the gray toolbar above the spreadsheet.
Step 4: Select the Number option.
The cell values should now be formatted correctly, without the dollar symbols. They should also preserve the two decimal positions that are usually preferred for currency values. If not, you can click the Decrease decimal places or Increase decimal places until the cell values are formatted to your liking.
Do you have cells with values that have a line drawn through them, and you would like to remove that line? Learn how to remove strikethrough in Google Sheets if you no longer wish to use it.
- How to merge cells in Google Sheets
- How to wrap text in Google Sheets
- How to alphabetize in Google Sheets
- How to subtract in Google Sheets
- How to change row height in Google Sheets
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.