How to Stop Showing a Dollar Sign in Excel 2013

Properly applied cell formatting in Microsoft Excel can make it much easier for your audience to understand the data that you are presenting. For example, if the values in your cells are displaying monetary values, and you have them formatted as simple numbers, then the lack of commas, or inconsistent decimal places, can be problematic.

But if you have already formatted your cells with the currency format, but find the dollar symbol that precedes the numbers to be unnecessary, then you might be wondering if that is something that you can adjust, while still keeping the rest of the currency formatting. Fortunately that is possible, and can be applied by following our short guide below.


Adjust the Formatting for Currency Cells in Excel 2013

The steps in this article will assume that the cells you want to modify are currently formatted as currency, and that you simply want to stop displaying the dollar symbol that is precedes the number. This article will show you how to keep the currency formatting, but remove the dollar sign from in front of the numerical value.

If you simply want to remove all of the formatting from your cells, this article will show you how.


Step 1: Open your spreadsheet in Excel 2013.


Step 2: Select the cells that you want to modify. In the example below I am changing the formatting for an entire column, so I have simply clicked the column letter at the top of the spreadsheet to select the entire column.

select the cells to reformat



Step 3: Right-click on one of the selected cells, then click the Format Cells option.

right-click the selected cells, then click format cells



Step 4: Click the drop-down box to the right of Symbol, then click the None option.

click the symbol menu, then click none



Step 5: Click the OK button to apply your changes.


Are there hidden cells in your spreadsheet that you need to edit? Learn how to show hidden cells in Excel 2013 so that you can make changes to the data they contain. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.