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
Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

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.


arrow blue right bubble This is just one of 120 powerful features of Kutools for Excel

It includes more than 120 advaned functions and tools for Excel 2007, 2010 and 2013 (includes Office 365).



btn read more     btn download     btn purchase

Add comment


Security code
Refresh