See all How-To Articles

How to Get Rid of Dollar Sign in Excel & Google Sheets

In this tutorial, you will learn how to get rid of the dollar signs in Excel and Google Sheets.

 

get rid of dollar sign 5

 

Get Rid of Dollar Sign Format

Say you have data set with products and prices, and the prices are formatted to include a dollar sign. There is an easy way to remove a dollar sign from currency-formatted cells.

 

get rid of dollar sign 1

 

1. First, select the cells with dollar signs you want to remove. Then in the Ribbon, (1) go to Home and in the Number group (2) click on the Number Format icon (little arrow at the right side of the bottom).

 

get rid of dollar sign 2

 

2. The Format Cells window will open. Under theĀ Number category (1) click on Accounting. In the menu on the right side, (2) click on the arrow next to the Symbol and from the drop-down menu, (3) choose None. When done (4) click OK.

 

get rid of dollar sign 3

 

As a result, the dollar sign is removed from the selected cells.

 

get rid of dollar sign 4

 

Get Rid of Dollar Sign in Google Sheets

To get rid of the dollar sign, first select the cells with dollar signs you want to remove. Then, in the Menu, click on Format > Number > Number.

 

get rid of dollar sign 7

 

As a result, the dollar sign is deleted from the selected cells.

 

get rid of dollar sign 7