Quickly Convert Currency in Excel 2007/2010

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

Quickly convert one value from one currency to another;
Quickly convert a range of data and overwrite the original value;
Quickly convert a range of data and insert into a new range as values.

Click "Kutools">>"Operation">>"Currency Conversion". See screenshots (Fig. 1).

Fig.1: Currency Conversion

To convert one value from one currency to another:

convert a single value

Fig. 2: Convert a Single Value dialogue box

Usage:

Choose the Convert a Single Value option;
Select the two currency from the left list box and the right list box;
Input a value in the left box, and you will get the result immediately.

Notes:

You could click Get latest rates button to get the latest currency exchange rate from reliable source (require internet connection);
The converted value will appear in the right box, which will be updated automatically, whenever you change the input value or the currency type.
The currency in the left list box is to be converted from, and the currency in the right list box is to be converted to.

To convert a range of data from one currency to another:

Fig. 3： Convert a Range dialogue box

Usage:

Choose the Convert a Range option;
Specify a range of data to be converted from in the Source range box; if the Overwrite source data is not checked, you need to specify a new range for inserting the results.
Select the currency from the left list box (to be converted from) and the right list box (to be converted to);
Click OK.

Notes:

If the Create conversion formulas option is checked, the result will be created in the form of formulas within the selected range.
The currency in the left list box is to be converted from, while the currency in the right list box is to be converted to.
You can press Undo (Ctrl+Z) to restore this operation immediately.

See Currency Conversion feature demo (video 1)

Video 1.Currency Conversion feature demo.