Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to quickly convert between dollars, pounds, euros in Excel?

For example you have a table listing some income and expenses in US dollar, and you want to convert them in Euros or Pounds, or vice verse. Which ways will you apply? There are several easy options for you to solve this problem:

Convert currencies between dollars, pounds, and euros with exchange rates

Convert currencies between dollars, pounds, and euros with Kutools for Excel

An example may be easy to understand. Supposing you have the following US dollars, now we will guide you to convert the US dollars to Euros and Pounds.

doc-dollar-euro-1


arrow blue right bubble Convert currencies between dollars, pounds, and euros with exchange rates


The most common way is to find out the exchange rate between two currencies. Take converting dollars to euros for example, you can do it with following steps:

1. Search the exchange rate between US dollar and euros, and the current exchange rate is 1 US Dollar = 0.726089 Euros at present.

2. In Cell B2 enter the formula =A2*0.726089, and press the Enter key.

doc-dollar-euro-2

3. Click the Cell B2, and drag the Fill Handle to copy this formula to the B3:B10. Then you will get all money in Euros in Column B.

doc-dollar-euro-3

4. You can also convert the US Dollars to UK Pounds, UK Pounds to Euros, UK Pounds to US Dollars, Euros to UK Pounds, and Euros to US Dollars easily with this way.


arrow blue right bubble Convert currencies between dollars, pounds, and euros with Kutools for Excel

Is it boring to search for the exchange rates every time when you need to convert currencies? There are so many currencies, and exchange rates between these currencies changes all the time. It's hard to get the exchange rates. Please do not worry about it, Kutools for Excel's Currency Conversion tool can help you get the latest exchange rates between any kinds of currencies, and help you convert between them quickly.

Kutools for Excel includes more than 300 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.

Step 1: Click Kutools > Content Converter > Currency Conversion. See screenshot:

doc-dollar-euro-4

Step 2: Select the range that you want to convert the currency, and in the Currency Conversion dialog box, specify the settings as following:

  • Select the source currency US Dollar from the left list box, and choose the currency EURO that you want to convert from the right list box;
  • Click Update rate button to get to the latest exchange rates.

doc-dollar-euro-5

Step 3: Then click Fill options button, in the Fill options prompt box, choose one output type that you want, then close the box to return to the Currency Conversion dialog, see screenshot:

doc-dollar-euro-6

Step 4: After specifying the output type, then click OK or Apply button, you will get the following results:

(1.) If you choose Only cells as output type, all the new converted currency values will replace the original values, see screenshots:

doc-dollar-euro-7 -2 doc-dollar-euro-8

(2.) If you choose Only comment as output type, all of the converted values and some detailed information will be inserted as comments into the original cells. See screenshot:

doc-dollar-euro-9

(3.) If you choose Cells and comment as the output result, the converted values will be filled into the original cells and the detailed information will be inserted as comments as well. See screenshot:

doc-dollar-euro-10

Kutools for Excel's Currency Conversion tools brings you a quick way to convert more than 50 currencies in your Excel by using the latest exchange rates from the reliable Internet web site. You can easily convert a single value or volume values from a range cells with current exchange rates. Click to know more…


Related article:

How to convert currencies in Microsoft Excel?


Recommended Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 71%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 82% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    rubel · 1 years ago
    This is very nice post. It is also very helpful for us.I have been searching types of tutorial because i love exchange .some days ago I read an article about exchange . but this post this better than post.
  • To post as a guest, your comment is unpublished.
    Amo globalfund · 3 years ago
    Dear sir/Madam,

    We can help you with a loan today, I want you to contact us if interested. Take an Immediate decision and contact us in our Home Office were loan transactions are process and transfer within the shortest possible period. amoglobalfund@gmail.com

    Personal Loan
    Business Loan
    Car Loan
    Debt consolidation Loans


    First Name:
    Surname:
    Gender:
    Country:
    state:
    Occupation:
    Contact phone number:
    Loan amount needed:
    Loan Duration:
    Purpose of loan:
    Monthly Income / Yearly Income:

    IF interested Fill immediately and return.

    Regards
    Amo Global Funding
  • To post as a guest, your comment is unpublished.
    Amo globalfund · 3 years ago
    you looking for a mortgage? Looking for a quick loan or a funding firm for a business deal, contact us today at Atlas-loan company for a loan or investment funding from $5,000.00 to $100,000,000.00.
    **Personal Loan (Secure and Unsecured)
    **Business Loan (Secure and Unsecured)
    **Car Loan (Secure and Unsecured)
    **Debt consolidation Loans (Secure and Unsecured)
    (amoglobalfund@gmail.com)
    Best Regards,
    Amo-loan company
  • To post as a guest, your comment is unpublished.
    dr g · 4 years ago
    Do you have a version that works on a MacBookPro operating system?