How to Convert Currency to a Number in Excel (6 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Convert Currency to Number in Excel: 6 Ways

To make the description more visible I’m just taking one column with some values where Currency is given.

Dataset of How to Convert Currency to Number in Excel


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.

Using Number Format to Convert Currency to Number

Therefore, the Currencies are converted into Numbers.

Read More: Convert Currency to Words in Excel


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.

Use of Format Cells Option to Convert Currency to Number

A dialog box of Format Cells will appear.

  • From there, select General.
  • Finally, click OK.

Format Cells dialog box to Convert Currency to Number

As a result, you will get the numbers converted from currency.


3. Using the 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)

Using VALUE Function to Convert Currency to Number

Here, the VALUE function will convert the currency into a number.

  • Press ENTER to get Value.

Used AutoFill to Convert Currency to Number


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.

Employing Text to Columns Convert Currency to Number in Excel

A Convert Text to Columns Wizard will appear.

  • Firstly, select Delimited.
  • Then, click Next.

  • Secondly, from Delimiters, select Other and type $..
  • Then, click Next.

Converting Currency to Number in Excel

  • 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.

Currency to Number Converted in Excel


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

5. Using Paste Special Feature to Convert Currency to Number

  • 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.


6. Use of Power Query for Converting Currencies

If the Power Query is available 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

Use of Power Query to Convert Currency to Number in Excel

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.

get Currency converted into a Number in an Excel sheet

Read More: Difference Between Accounting and Currency Format in Excel


Practice Section

In the practice section, you can practice the explained methods.

Practice Section of How to Convert Currency to Number in Excel


Download Practice Workbook


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


<< Go Back to Currency Format | Number Format | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shamima Sultana
Shamima Sultana

Shamima Sultana, BSc, Computer Science and Engineering, East West University, Bangladesh, has been working with the ExcelDemy project for 2 years. She has written over 75+ articles and reviewed 1000+ articles for ExcelDemy. She has also led several teams with Excel VBA and Content Development works. Currently, she is working as the Project Manager and oversees the day-to-day work, leads the services team, allocates resources to the right area, etc. Her work and learning interests vary from Microsoft... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo