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

  • 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

Recommended Productivity Software

Office Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).

arrow blue right bubbleClick Kutools >> Content Converter >> Currency Conversion. See screenshots:

shot-convert-currency-1
-1
shot-convert-currency-2

arrow blue right bubbleConvert 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 Converter > Currency Conversion).

shot-convert-currency-3

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-convert-currency-4

3. Then click Fill options button to choose one output type that you want, and then close the dialog see screenshot:

shot-convert-currency-5

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

                                                                 shot-convert-currency-3


shot-button2-1shot-button3
Overwrite the original valuesInsert results as commentoverwrite the original values and insert as comment
shot-convert-currency-6shot-convert-currency-7shot-convert-currency-8

arrow blue right bubbleConvert 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 Converter > Currency Conversion).

shot-convert-currency-3

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-convert-currency-9

3. Then click Fill options button to choose one output type that you want, and then close the dialog see screenshot:

shot-convert-currency-5

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

                                                                      shot-convert-currency-3


shot-button2-1shot-button3
Overwrite the original valuesInsert results as commentoverwrite the original values and insert as comment
shot-convert-currency-6shot-convert-currency-11shot-convert-currency-12

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-convert-currency-13
  • 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-convert-currency-13

arrow blue right bubbleSee Currency Conversion feature demo (video 1)

Video 1.Currency Conversion feature demo.


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 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

Kutools for Excel

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

Designed for Excel(Office) 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