Shamima Sultana
In Microsoft Excel, it is easy to convert the currency to a number. For different types of purposes, you may need to convert your stored currencies to numbers. In this article, I will show you 6 different ways of how to convert the currency to a number in Excel.
Download Practice Workbook
6 Ways to Convert Currency to Number in Excel
To make the description more visible I’m just taking one column with some values where Currency is given.
1. Using Number Format to Convert Currency to Number
By using Number Format I will convert the Currency into Numbers. It is one of the easiest ways to do it.
- First, select the cell range to convert Currency to Number. Here, I selected the range C5:C11.
- Then, go to the Home tab >> from Number group >> select Number.
Therefore, the Currencies are converted into Numbers.
Read More: How to Convert Alphabet to Number in Excel (4 Easy Ways)
2. Use of Format Cells Option in Excel
Now, I will use the Format Cells Option to convert the Currency into Numbers.
- To begin with, select the cell range to convert Currency to Number. Here, I selected the range C5:C11.
- Then, select any cell and right-click on it to bring the Context Menu Bar.
- From there select Format Cells.
A dialog box of Format Cells will appear.
- From there, select General.
- Finally, click OK.
As a result, you will get the numbers converted from currency.
Read More: How to Convert Percentage to Number in Excel (5 Easy Ways)
3. Using VALUE Function to Convert Currency to Number
If you want, you can use the VALUE Function to convert the Currency into Numbers.
- Firstly, select a cell to place the formula. Here, I selected cell C5.
- Then, type the following formula.
=VALUE(B5)
Here, the VALUE function will convert the currency into a number.
- Press ENTER to get Value.
- Now, use the Fill Handle to AutoFill the formula for the rest of the cells.
Read More: How to Convert Text to Number Using Formulas in Excel
Similar Readings
- How to Convert Percentage to Whole Number in Excel (4 Methods)
- Convert Text with Spaces to Number in Excel (4 Ways)
- How to Convert Exponential Value to Exact Number in Excel (7 Methods)
- Convert Degrees Minutes Seconds to Decimal Degrees in Excel
- How to Convert Hours and Minutes to Decimal in Excel (2 Cases)
4. Employing Text to Columns Feature
The Text to Columns feature is a wonderful way of conversion. It will help you to convert the Currency into Numbers.
- Firstly, select the cell range to convert Currency to Number. Here, I selected the range C5:C11.
- Secondly, go to the Data tab >> select Text to Columns.
A Convert Text to Columns Wizard will appear.
- Firstly, select Delimited.
- Then, click Next.
- Secondly, from Delimiters, select Other and type $..
- Then, click Next.
- Thirdly, click on the Destination icon.
- Now, select the cell range C5:C11 as a Destination.
- Finally, click on Finish.
Therefore, you will get the Number from Currency.
Read More: How to Convert Text to Number with Excel VBA (3 Examples with Macros)
5. Using Paste Special Feature to Convert Currency to Number
There is another way of converting Currency to Number by using the Paste Special Feature in Excel. It will help you to convert the Currency into Numbers in a blink of an eye.
- Firstly, select the cell range to convert Currency to Number. Here, I selected the range C5:C11.
- Secondly, press CTRL+C to Copy the numbers with currency
- Now, select an empty cell, and right-click on it to bring up the Context Menu Bar.
- Then, select the Paste Values option.
As a result, all the values are converted into a number from currency.
Read More: How to Convert Scientific Notation to Number in Excel (7 Methods)
6. Use of Power Query for Converting Currencies
If the Power Query is available to you also can use it cause Power Query doesn’t support any type of currency, so it automatically turns the Currency into a Number.
- To begin with, select the cell range to convert Currency to Number. Here, I selected the range C5:C11.
- Secondly, go to the Data tab >> select From Table/Range
A dialog box of Create Table will appear.
- Check, My table has headers option.
- Then, click OK.
A Power Query Editor will appear.
- Now, you can see values are stored as Numbers.
- From Close & Load select Close & Load.
Therefore you will get Currency converted into a Number in an Excel sheet.
Read More: Excel Convert to Number Entire Column (9 Simple Methods)
Practice Section
In the practice section, you can practice the explained methods.
Conclusion
In this article, I tried to explain how to convert the currency to a number in Excel. This explanation will help you to understand the ways. Last but not least, if you have any kind of suggestions, ideas, or feedback please feel free to comment down below.
Related Articles
- How to Convert Percentage to Decimal in Excel (7 Methods)
- How to Convert Degrees Decimal Minutes to Decimal Degrees in Excel
- Excel VBA to Convert Textbox Value to Number (2 Ideal Examples)
- How to Convert Date to Week Number of Month in Excel (5 Ways)
- How to Convert Month to Number in Excel (3 Easy Methods)
- Convert 3 Letter Month to Number in Excel (8 Suitable Methods)
