Note: The other languages of the website are Google-translated. Back to English

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.


Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

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.


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.


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:


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.


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:


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:


(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:


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?

The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Comments (6)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Do you have a version that works on a MacBookPro operating system?
This comment was minimized by the moderator on the site
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) ( Best Regards, Amo-loan company
This comment was minimized by the moderator on the site
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. 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
This comment was minimized by the moderator on the site
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.
This comment was minimized by the moderator on the site
I Am Mrs Lucy, I give out affordable loan at 3% interest rate. contact us at: with Your Full Name, Amount Needed, Loan Duration, Country, Mobile No.SENT VIA EMAIL US:
This comment was minimized by the moderator on the site

Do you find yourself in a bit of trouble with unpaid bills and don’t know which way to go or where to turn? What about finding a reputable Debt Consolidation firm that can assist you in reducing monthly installment so that you will have affordable repayment options as well as room to breathe when it comes to the end of the month and bills need to get paid? BENJAMIN LOAN INVESTMENTS FINANCE is the solution to your financial misfortune. We offer all types of loan ranging from $5,000.00 to $533,000,000.00USD with a low interest rate of 2% and loan duration of 1 to 35 years to pay back the loan secure and unsecured. Our loans are well insured for maximum security is our priority, Our leading goal is to help you get the services you deserve, Our program is the quickest way to get what you need in a snap. Kindly reduce your payments to ease the strain on your monthly expenses by Contacting us on the following Call/Text +1(415)630-7138 Email

Loan Offer Alert For Everyone! Are you financially down and you need an urgent credit/financial assistance? Or are you in need of a loan to start-up/increase your business or buy your dream house. GET YOUR INSTANT LOAN APPROVAL 100% GUARANTEED TODAY NO MATTER YOUR CREDIT SCORE.
There are no comments posted here yet
Leave your comments
Posting as Guest
Rate this post:
0   Characters
Suggested Locations