Quickly Convert Currency (USD to EURO / USD to GBP) in Excel

Excel does not support with a quick way to convert currency. When you need to convert a range of data from one currency to another, you may need to use other currency conversion tools or search the currency exchange rate to convert currency in Excel. But with Kutools for Excel’s Currency Conversion, you can easily get the latest currency exchange rate from reliable source and apply the following operation in Excel:

  • Convert currency and overwrite the original values
  • Convert currency and insert as comments
  • Convert currency and both overwrite the original values and insert as comments

arrow blue right bubble Click Kutools >> Content >> Currency Conversion. See screenshots:

shot currency conversion 1-1


arrow blue right bubble Convert USD to EURO

1. Please select a range of data which you want to convert to EURO as follows, and then apply this utility (Click Kutools > Content > Currency Conversion).

shot currency conversion 1

2. In the Currency Conversion dialog box, specify the currencies that you want to convert, and click Update rate to get the latest exchange rate. (If you cannot update the exchange rate, please make sure your Internet connection is OK, and then go to download and install the latest version of Kutools for Excel from our website.)

shot currency conversion 1

3. Click Fill options button to get into the Fill Options dialog box. Choose one output type, and specify a decimal place for the output values by checking the Decimal place box and enter the decimal place number into the textbox. then close the dialog see screenshot:

shot currency conversion 1

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

shot currency conversion 1


arrow blue right bubble Convert USD to GBP

1. Please select a range of data which you want to convert to GBP as follows, and then apply the utility (Click Kutools > Content > Currency Conversion).

shot currency conversion 1

2. In the Currency Conversion dialog box, specify the currencies that you want to convert, and click Update rate to get the latest exchange rate. (If you cannot update the exchange rate, please make sure your Internet connection is OK, and then go to download and install the latest version of Kutools for Excel from our website.)

shot currency conversion 1

3. Click Fill options button to get into the Fill Options dialog box. Choose one output type, and specify a decimal place for the output values by checking the Decimal place box and enter the decimal place number into the textbox. then close the dialog see screenshot:

shot currency conversion 1

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

shot currency conversion 1


arrow blue right bubbleNotes:

  • 1. You can press Undo (Ctrl+Z) to restore this operation immediately.
  • 2. Your used currencies will be kept, and you can click the drop down list to quickly select and convert them when you want to use it next time. See screenshot:
  • shot currency conversion 1
  • 3. If you want to enter your own currency rate to calculate the result, you just need to double click the rate at the bottom left corner in the Currency Conversion dialog, and then type the currency rate directly as you need.
  • shot currency conversion 1

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 200 Advanced Functions for Excel 2016, 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013, 2016 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

The functionality described above is just one of 200 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2016, 2013, 2010, 2007 and Office 365. Free download and use for 60 days.

Screen shot of Kutools for Excel

btn read more     btn download     btn purchase