While working with **Excel**, sometimes we notice that our data contains values in **Currency Format**. **Excel **automatically includes a **Dollar **symbol for the cells formatted as currency. What if, it is not the scenario we want? We want our numeric values as it is without any currency symbol. In this article, we will see different methods on** how to remove currency symbol in Excel**. We will use a sample dataset containing **Product ID**, **Products**, **State **and **Sales **where the sale values have currency symbol.

**Table of Contents**hide

## Download Practice Workbook

## 6 Ways to Remove Currency Symbol in Excel

In this post, we will guide you through 6 different methods including the **Format tab**, the **Find and Replace** option, and functions like **VALUE**, **REPLACE**, **RIGHT**, **SUBSTITUTE**.

### Method 1: Remove Currency Symbol Using Format Tab

The most used method to remove currency symbol in Excel is the **Format **tab.

**Steps:**

- First, select the entire range containing the currency symbol and press
**CTR+1**. As a result, a**dialogue box**will pop up.

- Now, select
**None**from the**Symbol**dropdown box and click**OK**.

That’s it, we will get the result as follows.

All the **currency **values are converted into **numbers**.

**Read More: How to Remove Dollar Sign in Excel Formula (2 Easy Ways)**

### Method 2: VALUE Function to Remove Currency Symbol

Using the **VALUE **function is another easy way to **remove currency symbol **and convert the value into numbers.

**Steps:**

- First, type the following formula in cell
**F5**.

`=VALUE(E5)`

- Now, press the
**ENTER**key.

- Finally, drag down to
**AutoFill**rest of the series.

Simple.

**Read More: How to Remove Sign from Numbers in Excel (6 Suitable Methods)**

### Method 3: Remove Currency Symbol with SUBSTITUTE Function

Now, we will see the use of the **SUBSTITUTE **function to remove the currency symbol.

We will use the formula if our data are in **Text **values.

**Steps:**

- First, type the following formula in cell
**F5**.

`=SUBSTITUTE(SUBSTITUTE(E5,"$",""),",","")`

- Now, press the
**ENTER**key.

- Finally, drag down to
**AutoFill**rest of the series.

Here, function **SUBSTITUTE(E5,”$”,””)** gives the output **“1000” **Further **=SUBSTITUTE(“1000″,”,”,””) **yields the inal result as **1000**.

**Read More:** **How to Remove Pound Sign in Excel (8 Easy Methods)**

### Method 4: Using RIGHT Function to Remove Currency Symbol

**RIGHT **function along with **LEN** function can be used to remove currency symbols if the values are in **TEXT**.

**Steps:**

- First, type the following formula in cell
**F5**.

`= RIGHT(E5,LEN(E5)-1)`

- Now, press the
**ENTER**key.

- Finally, drag down to
**AutoFill**rest of the series.

Here, **LEN(E5)-1** yields result **4**, as the currency symbol is the first character and we want to remove it, that’s why we used **-1**. Then **= RIGHT(E5,4)** will give us the output as **“1000”**. The **RIGHT** function took only the **4 **characters from the right side of the cell, as we know texts are always on the right side in **Excel**.

**Read More: How to Remove Sign in Excel (With 3 Examples)**

### Method 5: Remove Currency Symbol Using REPLACE Function

Here, we will see the use of another simple function **REPLACE**.

**Steps:**

- First, type the following formula in cell
**F5**.

`=REPLACE(E5,1,1,"")`

- Now, press the
**ENTER**key.

- Finally, drag down to
**AutoFill**rest of the series.

Here, in the **REPLACE** function, we’ve provided the cell reference and asked to replace the 1st character (since the currency symbol is in the 1st place) with null value (**“”**). Thus we’ve found the desired result.

**Read More: How to Remove Symbol in Excel (8 Ways)**

### Method 6: Using Find and Replace Feature

If we don’t want to use formula and our currency symbol containing cells are in **Text **format, **Find and Replace **is the easiest method to remove currency symbol in Excel.

**Steps:**

- Press
**CTRL+H**and a**dialogue box**will pop up.

- From the
**dialogue box**type**$**in**Find what**and keep the**Replace with**box**empty**and click**Replace All**.

Done. Easy.

## Practice Section

The single most crucial aspect in becoming accustomed to these quick approaches is practice. As a result, we’ve attached a practice workbook where you may practice these methods.

## Conclusion

That’s all for the article. These are 6 different methods for **how to remove currency symbol in Excel**. Based on your preferences, you may choose the best alternative. Please leave them in the comments area if you have any questions or feedback.