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

We’ll use a single column with some values in the Currency format.

Dataset of How to Convert Currency to Number in Excel


Method 1 – Using the Number Format to Convert Currency to Numbers

  • Select the entire cell range.
  • Go to the Home tab and, from the Number group, select Number.

Using Number Format to Convert Currency to Number

  • The Currencies are converted into Numbers.

Read More: Convert Currency to Words in Excel


Method 2 – Use the Format Cells Option in Excel

  • Select the cell range you want to convert Currency to Number.
  • Select any cell and right-click on it to bring the Context Menu Bar.
  • Select Format Cells.

Use of Format Cells Option to Convert Currency to Number

  • A dialog box for Format Cells will appear.

  • Select General.
  • Click OK.

Format Cells dialog box to Convert Currency to Number

  • You will get the numbers converted from currency.


Method 3 – Using the VALUE Function to Convert Currency to Numbers

  • Select the first cell to place the formula, such as C5.
  • Use the following formula.
=VALUE(B5)

Using VALUE Function to Convert Currency to Number

The VALUE function will convert the currency into a number.

  • Press Enter.

Used AutoFill to Convert Currency to Number


Method 4 – Using the Text to Columns Feature

  • Select the entire cell range.
  • Go to the Data tab and select Text to Columns.

Employing Text to Columns Convert Currency to Number in Excel

  • A Convert Text to Columns Wizard will appear.
  • Select Delimited.
  • Click Next.

  • From Delimiters, select Other and type $.
  • Click Next.

Converting Currency to Number in Excel

  • Click on the Destination icon.

  • Select the cell range C5:C11 as the Destination.

  • Click on Finish.

  • You will get the Numbers from Currency.

Currency to Number Converted in Excel


Method 5 – Using Paste Special to Convert Currency to Numbers

  • Select the cell range you want to convert.
  • Press Ctrl + C to Copy the numbers with currency

5. Using Paste Special Feature to Convert Currency to Number

  • Select an empty cell and right-click on it to bring up the Context Menu Bar.
  • Select the Paste Values option.

  • All the values are converted into numbers.


Method 6 – Use Power Query for Converting Currencies

  • Select the cell range.
  • Go to the Data tab and select From Table/Range

Use of Power Query to Convert Currency to Number in Excel

  • A dialog box of Create Table will appear.
  • Check the My table has headers option.
  • Click OK.

  • A Power Query Editor will appear.
  • You can see values are stored as Numbers.

  • From Close & Load, select Close & Load.

  • You will get Currency values converted into Numbers 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

You can practice the explained methods in a dedicated section from our workbook.

Practice Section of How to Convert Currency to Number in Excel


Download the Practice Workbook


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
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