How to Remove the Dollar Sign in MS Excel

Do you want to remove the default dollar sign from your numbers in MS Excel? Or it might be another currency, depending on your region, but removing them usually makes your document less cluttered.

Currency symbols are important in financial documents as they enhance the document’s comprehensibility. But most of the time, we do not need them. So, to remove these currency signs, you can use the different methods given below. Whether it is a $ or other currency, the steps are the same.

3 Methods to remove the dollar sign in Microsoft Excel:

  • Change the formatting of the numbers
  • Use the Format Cells dialog box
  • Use the VALUE function

Let us begin by having a look at these methods one by one.


Method #1: Change the Formatting of the Numbers

This is the simplest method to remove the dollar sign in MS Excel. One thing to note here is that this method also removes commas from between the numbers.

Step #1: Open an Excel workbook

Open a new Excel file. If you already have an existing workbook in which you want to perform this exercise, open that. Make sure the workbook has numbers formatted as currency to perform this exercise.

Step #2: Change the formatting of the numbers

Select the cell with the dollar sign by clicking on it. 

To select multiple cells, click and drag the cursor over the cells. 

Navigate to the Home tab ribbon and look for the Number Format drop-down box.

Click on the little arrow to the right of it.

A drop-down menu will open. 

Click on General, to remove the $ sign, or even Number, Fraction, or Text.

As you can see, the dollar sign has been removed.


Method #2: Use the Format Cells Dialog Box 

This method removes the dollar sign, keeping the commas between the numbers intact.

Step #1: Open an Excel workbook

Open a new Excel file. If you already have an existing workbook in which you want to perform this exercise, open that. Make sure the workbook has numbers formatted as currency to perform this exercise.

Step #2: Open the Format Cells dialog box

Select the cell with the dollar sign by clicking on it.

Open the Format Cells dialog box. You can do this by either:

  • Clicking right and from the menu that opens, select Format cells…
  • Click on Format in the Menu Bar and then Cells…
  • Use the keyboard shortcut command and 1 for Mac users.
  • Use the keyboard shortcut Alt H F M pressed successively.
  • Click on the dialog box launcher from the Number group under the Home tab. This is the little icon next to the word Number, on the Home ribbon.

Step #3: Select the None option from Symbol drop-down

Once the Format Cells dialog box opens, select the Number tab.

Click on the Symbol drop-down and select the None option.

Step #4: Press Enter

After selecting None, click the OK button or press Enter on your keyboard.


Method #3: Use the VALUE Function

This method is not much different from Method #1. You can use this method if you don’t want to or can’t make changes to the original data.

Step #1: Open an Excel workbook

Open a new Excel file. If you already have an existing workbook in which you want to perform this exercise, open that. Make sure the workbook has numbers formatted as currency to perform this exercise.

Step #2: Using the VALUE function

Select a cell next to the cell with the currency by clicking on it.

In the cell, type the following formula:

=VALUE(text)

The meaning of the arguments is given below:

  • text: The name of the cell with the currency symbol.

In our example:

=VALUE(A1)

Step #3: Press Enter

After typing the formula, press Enter on your keyboard to execute it.


Conclusion

Although we have given you three methods to remove the dollar sign in MS Excel, we find Method #1 the easiest. It works for any default currency, set according to your region.

If you still want commas to separate digits, click on the comma sign from the Number menu under the Home tab.

Leave a Comment