How to Format Money Without the Dollar Sign in Excel 2013

There is often a difference in the way your data appears in cells in Excel 2013 spreadsheets. The number of displayed decimal places can vary depending on the entered amounts so, if you are dealing with monetary values, it’s helpful to keep them consistent by formatting those values as currency.

But the default currency formatting in Excel 2013 includes a dollar sign in front of the numbers, which is something that you may not want. Luckily you have control over many aspects of the currency formatting, including whether or not that dollar sign is there. Our guide below will show you the option to adjust if you wish to remove that dollar sign from your currency-formatted cells.


How to Remove the Dollar Sign from Numbers in Excel 2013

The steps in this article will assume that the dollar sign is being added to your cell data due to an existing currency formatting setting. If the dollar signs have been entered manually, then adjusting the formatting in this manner may not work.

Step 1: Open your spreadsheet in Excel 2013.


Step 2: Select the cells containing the dollar sign formatting that you want to remove. You can select an entire column by clicking the column row letter, or an enter row by clicking the column row number.

change money formatting in excel 2013



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

no dollar signs in front of money



Step 4: Click the Currency option in the column at the left side of the window, click the Symbol dropdown menu and select the None option, then click the OK button at the bottom of the window.

remove dollar sign formatting excel 2013



Have you downloaded a bunch of CSV files that you need to combine into one file, but copying and pasting all of that data will be tedious? Learn about a simple way to quickly combine multiple CSV files using the command prompt.