How to convert currency in microsoft excel

Do you want to know how to change the currency symbol (i.e. $), positive currency format and other formats in Windows 10 computer? For your reference, this article illustrates how to customize currency format in detail.

Video guide on how to customize currency format on Windows 10:

Steps to customize currency format on Windows 10:

Step 1: Click the bottom-left Start button on desktop, type currency in the search box and tap Change the way currency is displayed.

How to convert currency in microsoft excel

Step 2: Open Additional settings in the Region window.

How to convert currency in microsoft excel

Step 3: Choose Currency, change the formats of currency symbol, positive currency, negative currency, decimal symbol, no. of digits after decimal, digit grouping symbol or digit grouping, and then click OK.

How to convert currency in microsoft excel

Related Articles:

Hot Articles How to convert currency in microsoft excel How to Reset Windows 10 Forgotten Password How to convert currency in microsoft excel How to Bypass Windows 10 Password Login with/without Password How to convert currency in microsoft excel Easy Guide to Reset Windows 10 Admin Password Like an Expert How to convert currency in microsoft excel 4 Tips to Change Windows 10 Password without Knowing Current Password How to convert currency in microsoft excel Can’t Sign into Microsoft Account Windows 10 | Account Locked/Blocked More + Hot Categories Windows 10 Password Windows 8 Password Windows 7 Password More + Latest Articles How to Calculate Power Consumption of a PC 7 Useful Commands Windows 10 Users Should Know 7 Ways to Access System Restore in Windows 10 How to Create or Delete Partitions Using Command Prompt How to Format Disk Partition Using Command Prompt How to Enable and Use God Mode in Windows 10 More + Hot Products Windows Password Genius iTunes Password Genius Product Key Finder More +

How to convert currency in microsoft excelFigure 1. of Currency Conversion in Excel.

In order to convert a Currency to other specified currencies, we can utilize the Excel VLOOKUP Function.

The Excel VLOOKUP Function operates by using various country Currency Codes that we are required to provide.

Generic Formula.

=VLOOKUP(currency,xtable,column,0)*amount

Note – xtable is the range of cells for a second table which specifies the current Currency Exchange Rates.

How to use the Excel Currency Conversion Function.

We can utilize The Excel VLOOKUP Function to help us in converting USD amounts to other currencies by using their currency codes.

We can carry out this operation in the following simple steps!

  1. Set up your Excel worksheet with the relevant details.

Provide separate columns for the currency symbol and current Currency Conversion Rates. This will be our xtable. See figure below;

How to convert currency in microsoft excelFigure 2. of Simple Currency Conversion in Excel.

  1. Click on cell D2 in the AMOUNT column and enter the operation syntax provided below in the formula bar of our worksheet.

=VLOOKUP(C2,F2:G7,2,0)*A2

This will convert the amounts located in the USD column into the currency we have indicated the SYMBOL column.

Note – our xtable cell range for this illustration is F2:G7

  1. Copy the operation syntax into the next cell D3 of the AMOUNT column as displayed below;

How to convert currency in microsoft excelFigure 3. of Simple Currency Conversion in Excel.

The Vlookup operation syntax locates the currency in the Excel Table, and then retrieves the current Currency Conversion Rate from column G and converts the USD amount.

The basis of this operation is the VLOOKUP Function .

How to convert currency in microsoft excelFigure 4. of Final Result.

Instant Connection to an Expert through our Excelchat Service:

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes

Provided that you have a large currency report is populated with USD, and now you would like to convert the USD to your own county currency, such as EURO. How could you convert the large data at once?

Convert currency in Excel with Excel function

Supposing you have a budget with US dollar, and you need to convert the data into Euro in Excel. You can use formula as follows:

1. Find out the current exchange rate between US dollar and Euro, and enter it in a blank cell. In this case, 1 US dollar = 0.88462 euros. So enter 0.88462 in Cell C2.

2. in Cell D2, enter the formula of = B2*$C$2, and drag the fill handle over the range cell that you want to contain the formula. And all cells in D2:D10 are filled with converted EUROS. See screenshot:
How to convert currency in microsoft excel

Easily convert currencies with latest exchange rate in Excel

In general, we need to get the latest exchange rate between the two specified currencies, and then multiply the latest exchange rate to convert the original currency to the given currency. But, with Kutools for Excel’s Currencies Conversion utility, it can automatically multiplying the latest exchange rate for easily batch converting currencies in Excel. Full Feature Free Trial 30-day!
How to convert currency in microsoft excel

Kutools for Excel – Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

Convert currency in Excel with Kutools for Excel

It may be tedious to search for current exchange rates every time when you need to convert currencies. Kutools for Excel‘s Currency Conversion tool can provide all kinds of current exchange rates, and convert any currencies quickly and conveniently.

Kutools for Excel – Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

1.Click Kutools > Content > Currency Conversion. See screenshot:
How to convert currency in microsoft excel

2. Highlight the range that you want to convert. and configure In Currency Conversion dialog as follows:
(1) Select the source currency U.S. Dollar from the left list box;
(2) Choose the currency EURO that you want to convert from the right list box;
(3) Click Update rate button to get the latest exchange rates;
(4) Then click Fill options button.
How to convert currency in microsoft excel

3. In the Fill options dialog box, choose one output type that you want and close the box, and also you can specify the decimal place of the out put result, see screenshot:
How to convert currency in microsoft excel

4. After specifying the output type, if you select Only cells, then click OK or Apply button, you will get the following results:

(1) If you select Only cells, all of the converted values will replace the original currency values. See screenshot:
How to convert currency in microsoft excel

(2) If you select Only comment, all of the converted values will be inserted as comments into the original cells. See screenshot:
How to convert currency in microsoft excel

(3) And if you choose Cells and comment as the output result, the converted values will be filled into the original cells, at the same time, the detailed information will be inserted as comments. See screenshot:
How to convert currency in microsoft excel

Kutools for Excel’s Currency Conversion tool brings you a quick way to convert more than 50 currencies in your Excel by using the latest exchange rates from the reliable Internet website. You can easily convert a single value or volume values from a range cells with current exchange rates. Have a Free Trial!

Microsoft Excel does not consist of integrated tools to convert currency. However, you can use an external information source to offer updated rates. A fundamental multiplication formula will then transform from one currency to another. Here’s how you do it!

Adding an External Data Source to Excel

An external data source is the best method to get up-to-date currency exchange rates. You can use this information to transform from one currency to another in Excel. The process is similar to transforming currency in Google Sheets.

You require a suitable online information source (in the XML format) that you can import into your spreadsheet. FloatRates has different XML feeds based around different currencies that you can use.

After you find the one you wish to use, open your Excel spreadsheet. In Excel 2019 or Office 365, click Data > > Get Data > > From File > From XML. In older versions of Excel, click Data > > Get External Data > > From Other Sources > > From XML Data Import instead.

For our example, we’re utilizing the FloatRates USD data feed, so we import that into Excel.

In the “Import Data” window, paste the URL to your XML data feed in the “File Name” box, and then click “Import.”

If you have Office 2019 or 365, you see a sneak peek of how the information will be imported. If you’re utilizing FloatRates data, you need to transform it in the Excel Power Query Editor to utilize it.

To do so, click “Transform Data.”

The Excel Power Query Editor appears. Scroll to the “Item” column, and after that double-click “Table” to pack the current currency rates.

The Power Query Editor preview updates and shows the FloatRates currency information. Click “Close and Load” in the top-left corner to add the information to your spreadsheet.

The data you import appears in a new worksheet, to which you can now refer when you need to transform currency.

Most external data sources update hourly, however FloatRates just updates every 12 hours. If you wish to upgrade your information by hand, click Data > >

Refresh All. Transforming Currency in Microsoft Excel

You can use the up-to-date data you imported to transform currency figures with a basic multiplication formula.

Click the worksheet with your imported currency rates. If you’re using FloatRates information, take a look at the exchange rates under the “exchangeRate” column. Note the cell that contains the rate of the currency to which you wish to convert.

Using our FloatRates U.S. dollar information, we see that to convert from U.S. dollars to British pounds, we require to utilize the GBP exchange rate in cell I3.

Go back to your existing worksheet, and type the USD cost from which you want to convert into a cell. In a second cell, utilize the formula =A2 * Sheet2!$I$ 3, and change “A2” with the cell which contains your USD price.

Change the 2nd part of the formula with an absolute referral to the cell in the “exchangeRate” column on your imported data worksheet that contains the exchange rate to which you wish to convert.

In the example above, Column A lists U.S. dollars. Column B lists the converted currency rates from U.S. dollars to British pounds (1 USD to GBP remains in cell B2).

When you alter the outright cell reference and use alternative data sources (like the FloatRates GBP information source to convert from GBP to other currencies), you can transform from any currency to another.

You can likewise utilize a manual rate rather of an external data source to transform currency rates. Just set the exchange rate by hand in a cell (in our example, cell B2), and the price in another (cell A3).

The exact same reproduction formula transforms your currency. Nevertheless, if you’re not utilizing an external data source, you’ll need to upgrade the rate manually to see the correct rate.

You can utilize an external information source to offer current rates. An external information source is the best method to get updated currency exchange rates. You can use this information to transform from one currency to another in Excel. The Power Query Editor preview updates and shows the FloatRates currency information. You can also utilize a manual rate instead of an external information source to convert currency rates.

Microsoft Excel doesn’t include built-in tools to convert currency. However, you can use an external data source to provide up-to-date rates. A basic multiplication formula will then convert from one currency to another. Here’s how you do it!

Adding an External Data Source to Excel

An external data source is the best way to get up-to-date currency exchange rates. You can use this data to convert from one currency to another in Excel. The process is similar to converting currency in Google Sheets.

First, you need a suitable online data source (in the XML format) that you can import into your spreadsheet. FloatRates has various XML feeds based around different currencies that you can use.

After you find the one you want to use, open your Excel spreadsheet. In Excel 2019 or Office 365, click Data > Get Data > From File > From XML. In older versions of Excel, click Data > Get External Data > From Other Sources > From XML Data Import instead.

For our example, we’re using the FloatRates USD data feed, so we import that into Excel.

In the “Import Data” window, paste the URL to your XML data feed in the “File Name” box, and then click “Import.”

If you have Office 2019 or 365, you see a preview of how the data will be imported. If you’re using FloatRates data, you have to convert it in the Excel Power Query Editor to use it.

To do so, click “Transform Data.”

The Excel Power Query Editor appears. Scroll to the “Item” column, and then double-click “Table” to load the up-to-date currency rates.

The Power Query Editor preview updates and shows the FloatRates currency data. Click “Close and Load” in the top-left corner to add the data to your spreadsheet.

The data you import appears in a new worksheet, to which you can now refer when you need to convert currency.

Most external data sources update hourly, but FloatRates only updates every 12 hours. If you want to update your data manually, click Data > Refresh All.

Converting Currency in Microsoft Excel

You can use the up-to-date data you imported to convert currency figures with a simple multiplication formula.

Click the worksheet with your imported currency rates. If you’re using FloatRates data, look at the exchange rates under the “exchangeRate” column. Note the cell that contains the rate of the currency to which you want to convert.

Using our FloatRates U.S. dollar data, we see that to convert from U.S. dollars to British pounds, we need to use the GBP exchange rate in cell I3.

Return to your existing worksheet, and type the USD price from which you want to convert into a cell. In a second cell, use the formula =A2*Sheet2!$I$3 , and replace “A2” with the cell that contains your USD price.

Replace the second part of the formula with an absolute reference to the cell in the “exchangeRate” column on your imported data worksheet that contains the exchange rate to which you want to convert.

In the example above, Column A lists U.S. dollars. Column B lists the converted currency rates from U.S. dollars to British pounds (1 USD to GBP is in cell B2).

When you change the absolute cell reference and use alternative data sources (like the FloatRates GBP data source to convert from GBP to other currencies), you can convert from any currency to another.

You can also use a manual rate instead of an external data source to convert currency rates. Just set the exchange rate manually in a cell (in our example, cell B2), and the price in another (cell A3).

The same multiplication formula converts your currency. However, if you’re not using an external data source, you’ll have to update the rate manually to see the correct price.

With the Currencies data type you can easily get and compare exchange rates from around the world. In this article, you’ll learn how to enter currency pairs, convert them into a data type, and extract more information for robust data.

Note: Currency pairs are only available to Microsoft 365 accounts (Worldwide Multi-Tenant clients.)

Use the Currencies data type to calculate exchange rates

Enter the currency pair in a cell using this format: From Currency / To Currency with the ISO currency codes.

For example, enter “USD/EUR” to get the exchange rate from one United States Dollar to Euros.

Select the cells and then select Insert > Table. Although creating a table isn’t required, it’ll make inserting data from the data type much easier later.

With the cells still selected, go to the Data tab and select the Currencies data type.

If Excel finds a match between the currency pair and our data provider, your text will convert to a data type and you’ll see the Currencies icon in the cell.

Note: If you see in the cell instead of the Currencies icon, then Excel is having difficulty matching the text with data. Correct any mistakes and press Enter to try again. Or, select the icon to open the Data Selector where you can search for a currency pair or specify the data you need.

To extract more information from the Currencies data type, select one or more converted cells and select the Insert Data button that appears or press Ctrl/Cmd+Shift+F5.

You’ll see a list of all the fields available to choose from. Select the fields to add a new column of data.

For example, Price represents the exchange rate for the currency pair, Last Trade Time represents the time the exchange rate was quoted.

Once you have all the currency data that you want, you can use it in formulas or calculations. To ensure your data is up to date, you can go to Data > Refresh All to get an updated quote.

Caution: Currency information is provided “as-is” and may be delayed. Therefore, this data should not be used for trading purposes or advice. See About our data sources for more information.

How to convert currency in microsoft excel

Excel can convert currency given the right tools. While there are dozens of currency conversion websites or other conversion tools that you can use online or purchase, they work best for looking up one currency transaction at a time. If, on the other hand, you need a table of multiple transactions or currencies for multiple countries, you can use Excel to accomplish this task with the Excel Add-In called EUROTOOL.XLAM.

Note that to keep up with currency fluctuations, your usage with Excel should include an Internet connection, so you can receive updates. We’ve provided a worksheet for you to practice using the currency conversion techniques in this story:

Install / Load the Euro Currency tool

If you try to use this function and receive an error, you must first install and load this tool.

1. Select File > Options > Add-Ins

2. Scroll down to the Add-In called EUROTOOL.XLAM

3. Click to select it, then click OK.

How to convert currency in microsoft excel

JD Sartain / IDG Worldwide

01 An online currency converter can take you only so far, which is why you might want to install Excel’s Euro Currency tool.

4. The syntax for this command is: =EUROCONVERT(number,source,target,full_precision,triangulation_precision).

5. To locate, select Formulas (tab) > Insert Function (button in the Function Library group). In the Insert Function dialog window, click the down arrow beside the Or select a category field box, then scroll down and select EUROCONVERT.

6. Click OK and the Function Arguments dialog opens.

7. All of the arguments shown here (number,source,target,full precision,triangulation precision) in this command are required and defined as follows:

a. Number: This is the currency value you want to convert (can also be a cell address for the location of this value).

b. Source: This is the three-letter ISO code for the source currency; e.g., Spain equals ESP. This can also be a cell address for the location of this code.

c. Target: This is the three-letter ISO code for the target currency; e.g., France equals FRF. This can also be a cell address for the location of this code.

d. Full Precision: Either TRUE or FALSE. True means all significant digits (from the calculation) are displayed. False means the result is shown with the currency-specific rounding rules applied; that is, the rules that determine how the results are rounded—up or down to the nearest cent; to the nearest unit or sub-unit; or to a multiple or fraction of the unit or sub-unit. Note that for a result that is exactly halfway, the sum is rounded up. False is the default if the Full Precision argument is omitted. In other words, if you don’t enter anything (true or false), Excel assumes the answer is FALSE.

e. Triangular Precision: Excel store 15 significant digits of precision. In some situations, this can be a problem. For this argument, you can set the number of digits equal to or greater than 3. Confused? See examples in screenshot images.

8. Enter the appropriate arguments, then click OK.

How to convert currency in microsoft excel

JD Sartain / IDG Worldwide

02 Select EUROCONVERT and enter appropriate arguments.

NOTE: The EUROCONVERT function in Excel does not convert United States dollars, just the following countries to and from one another: Euros, Austria, Belgium, Finland, France, Germany, Greece, Ireland, Italy, Luxembourg, Netherlands, Portugal, and Spain.

I have no idea why Microsoft would create a function that does not include the United States! However, there is a workaround.

1. Copy or download the EUROCONVERT table from the Internet and paste it into your spreadsheet, or download this spreadsheet and use ours.

2. Because the EUROCONVERT function won’t convert dollars, the work-around is to select a cell at the top of the spreadsheet (e.g., C2) and enter the current conversion rate for one Euro that equals one dollar (that is, $1.14).

3. Next, use the EUROCONVERT function to convert 90 Euros to dollars ($102.60). To do that, enter this formula in cell D20: =SUM(C20*$C$2). C2 is the cell that contains the dollar amount for one Euro (that is, $1.14). See spreadsheet or figure 03.

4. In D21, enter this formula: =EUROCONVERT(C21,$D$17,D8,FALSE,10) where C21 is the location of the number of Euros you want converted; $D$17 is the location of the Euro code; D8 is the location of the code for French Francs; FALSE is the Full Precision code for specific rounding rules applied; and 10 is Triangular Precision (a safe number for the significant digits of precision).

5. In summary, 90 Euros equals $102.60 dollars, and 90 Euros equals 590.36 Francs; so $102.60 equals 590.36 Francs.

How to convert currency in microsoft excel

JD Sartain / IDG Worldwide

Excel provides you different ways to calculate percentages. For example, you can use Excel to calculate the percentage of correct answers on a test, discount prices using various percent assumptions, or percent change between two values. Calculating a percentage in Excel is an easy two-step process. First, you format the cell to indicate the value is a percent, and then you build the percent formula in a cell.

How to convert currency in microsoft excel

Microsoft Excel

Turn data into insights.

Format values as percentages

To show a number as a percent in Excel, you need to apply the Percentage format to the cells. Simply select the cells to format, and then click the Percent Style (%) button in the Number group on the ribbon’s Home tab. You can then increase (or decrease) the the decimical place as needed. (See Rounding issues below for more information.)

How to convert currency in microsoft excel

In Excel, the underlying value is always stored in decimal form. So, even if you’ve used number formatting to display something as a percentage (10%), that’s just what it is—formatting, or a symbolic representation of the underlying value. Excel always performs calculations on that underlying value, which is a decimal (0.1). To double-check the underlying value, select the cell, press Ctrl + 1, and look in the Sample box on the General category.

How to convert currency in microsoft excel

Here are a few things to keep in mind when formatting percentages:

Format existing values—When you apply percentage formatting to a cell that already has a number in it, Excel multiplies that number by 100 and adds the % sign at the end. So for example, if you type 10 into cell A2 and then apply the percentage number format, Excel will multiply your number by 100 to show it as a percentage (remember that 1% is one part of one hundred), so you’ll see 1000% displayed in the cell, not 10%. To get around this, you can calculate your numbers as percentages first.

For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you ‘d expect. You can also just type the number in its decimal form directly into the cell—that is, type 0.1 and then apply percentage format.

Rounding issues—Sometimes what you see in a cell (e.g., 10%) doesn’t match the number you expected to see (e.g., 9.75%). To see the true percentage in the cell, rather than a rounded version, increase the decimal places. Again, Excel always uses the underlying value to perform calculations.

Format empty cells—Excel behaves differently when you pre-format empty cells with percentage formatting and then enter numbers. Numbers equal to and larger than 1 are converted to percentages by default; numbers smaller than 1 that are not preceded with a zero are multiplied by 100 to convert them to percentages. For example, if you type 10 or .1 in a preformatted cell, you’ll see 10% appear in the cell. Now, if you type 0.1 in the cell, Excel will return 0% or 0.10% depending on the decimal setting.

Format as you type—If you type 10% directly in the cell, Excel will automatically apply percentage formatting. This is useful when you want to type just a single percentage on your worksheet, such as a tax or commission rate.

Negative percentages—If you want negative percentages to be formatted differently—for example, to appear as red text or within parentheses—you can create a custom number format such as 0.00%;[Red]-0.00% or 0.00%_);(0.00%).

Calculating percentages

As with any formula in Excel, you need to start by typing an equal sign (=) in the cell where you want your result, followed by the rest of the formula. The basic formula for calculating a percentage is =part/total.

In the example below, Actual Points/Possible Points = Grade %:

How to convert currency in microsoft excel

Say you want to reduce a particular amount by 25%, like when you’re trying to apply a discount. Here, the formula will be: =Price*1-Discount %. (Think of the “1” as a stand-in for 100%.)

How to convert currency in microsoft excel

To increase the amount by 25%, simply replace the minus sign in the formula above with a plus sign.

The next example is slightly more complicated. Say the earnings for your department are $2,342 in November and $2,500 in December and you want to find the percentage change in earnings between these two months. To find the answer, divide the difference between December and November earnings ($158) by the value of the November earning ($2,342).

How to convert currency in microsoft excel

Learn more

Editor’s note 3/7/2019:
This blog post was updated to reflect the blog’s current editorial style.

My clients keep asking me to display large numbers like in Thousands or Million to display in a shorter form. In the business world, K or M are used to represent Thousands or Millions.

For my own small Training business, I haven’t reached the revenue target of Million Dollar Sales…

But yes, I do achieve sales of several thousand from my blogs each month (PMChamp & ExcelChamp) and my Training company in Singapore & SkillsFuture Training Courses in Singapore.

How to convert currency in microsoft excel

Large Numbers showing in K or M in Excel

However, my clients are usually small and medium enterprises as well as Multi-national companies, whose revenue is usually in Millions and sometimes in Billions too 🙂

Difficult to Read, Large Numbers look ugly in Excel
The problem is that for some people, it becomes difficult to read numbers and figures in Thousands, Millions and Billions, with so many zeroes to count.

And for our neighboring country Indonesia, the currency denomination is so small, that a rent of a one room apartment in Jakarta may be anywhere from 5 million to 10 million Indonesian Rupiah. So you can easily imagine how doing a simple budgeting exercise can take you into dizzying heights of billions and trillions.

How To Add a Thousand or Million Suffix to Numbers in Excel

For huge numbers, it is easier to read $23M or $25K rather than $23,000,000 or $23,000.

So let’s see how you can convert a large number in Thousands, Millions or Billions to be an easy to read number with Microsoft Excel.

How to convert currency in microsoft excel

  1. Simply select the number cell, or a range of numbers that you would like to convert into K or M.
  2. Right Click, and choose Custom Formatting.
    You can also choose Number Formatting from the HomeRibbon, or simply press the shortcut [Ctrl] + 1.
  3. Go to Custom, and key in 0, “K” in the place where it says General. Now close the Format Cells popup window.Custom Number Format Popup in Microsoft Excel
  4. Voila! Now your large number will be displayed in Thousands. So 23000 becomes 23K.

How To Display Numbers in Millions in Excel

  1. Right Click any number you want to convert. Go to Format Cells. In the popup window, move to Custom formatting.
  2. If you want to show the numbers in Millions, simply change the format from General to 0,,”M”. The figures will now be 23M. So essentially we are adding 2 commas instead of a single comma this time.
  3. If you would like to see the decimal point for the millions figure, like 23.6M, you can format it to 0.0,,”M”
  4. What’s great is that if you now create a chart on this data, the chart or Pivot Table will now show the figure in this custom format.
  5. Thus you will see the chart displaying numbers in Millions, or Thousands… saving space, and making the chart or pivot easier to read and analyze.

That’s it! Spend more time analyzing, not staring at the huge numbers 😉

You can check this out for yourself, by downloading the Sample Excel File. It has a few scenarios where you can try to convert large numbers into Millions or Thousands, whatever you prefer.

Sample Excel File Download: Number_formatting_in_K_or_M.xlsx

This technique applies to Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019 & Microsoft Office 365 editions.

It would work in all versions of Microsoft Excel in the past 20 years…

Hope it helps! Do share it with others on Facebook or LinkedIn.

And do comment or write to tell me of any issues you are facing in using Excel everyday. There may be a simple solution that can save you a lot of time. At ExcelChamp, I solve many small problems each day to make Excel easy for every one.

Lori Kaufman
How to convert currency in microsoft excelLori Kaufman
Writer

Lori Kaufman is a technology expert with 25 years of experience. She’s been a senior technical writer, worked as a programmer, and has even run her own multi-location business. Read more.

How to convert currency in microsoft excel

If you’re working with different currencies in one Excel spreadsheet, you’ll need to change the currency symbol on certain cells, without affecting other cells. When you format your numbers as “Currency”, you can easily use multiple currency symbols in the same Excel spreadsheet.

NOTE: If you’re going to use the same currency symbol throughout your Excel spreadsheets, you can change the default currency symbol throughout Windows instead. This is for situations when you want two different currency symbols in the same document.

Before you do anything else, make sure the numbers in question are formatted as currency. To do this, select the cells you want to format.

How to convert currency in microsoft excel

Then, select “Currency” from the “Number Format” drop-down list in the “Number” section of the “Home” tab.

How to convert currency in microsoft excel

The numbers in the selected cells are all formatted as currency with Windows’ default currency symbol applied.

To change some of the currency numbers to another type of currency, such as Euros, select the cells you want to change.

How to convert currency in microsoft excel

In the “Number” section of the “Home” tab, click he “Number Format” button in the lower-right corner of the section.

How to convert currency in microsoft excel

On the “Number” tab, “Currency” should be selected in the “Category” list. Click on the “Symbol” drop-down list, scroll down to the “Euro” options and select one, depending on whether you want the Euro symbol before or after the number. Click “OK”.

How to convert currency in microsoft excel

The selected numbers now have a different currency symbol applied to them.

How to convert currency in microsoft excel

You may have noticed a drop-down list in the “Number” section of the “Home” tab that has a currency symbol on it. This may seem like an easier way to change the currency symbol for the selected cells. However, this is the “Accounting Number Format”, not the standard currency format.

How to convert currency in microsoft excel

If you select “Euro” from the “Accounting Number Format” drop-down list…

How to convert currency in microsoft excel

…you’ll get Euro symbols on your numbers, but they will display in the accounting format, which aligns the decimal points in a column. Notice that the currency symbols are not right next to the numbers. Instead, they are left-aligned.

How to convert currency in microsoft excel

You can also change the number of decimal places and the format of negative numbers on the “Number” tab on the “Format Cells” dialog box.

  • › Samsung Now Offers Apple-Style Same Day Repairs at Best Buy
  • › What Is a Zero-Click Attack?
  • › The Best Alternatives to Google Apps on Android
  • › How Do Drones Actually Fly?
  • › How to Generate a Web Link QR Code in Google Chrome

How to convert currency in microsoft excel Lori Kaufman
Lori Kaufman is a technology expert with 25 years of experience. She’s been a senior technical writer, worked as a programmer, and has even run her own multi-location business.
Read Full Bio »