Click the worksheet with your imported currency rates. Converting currency in microsoft excel.
Convert currency in excel with kutools for excel 1 select the source currency u s.
How to convert money in excel. Look up your current conversion rate. It s a green app with a white x on it. 3 click update rate button to get the latest exchange rates.
You can use the up to date data you imported to convert currency figures with a simple multiplication formula. Create a conversion table for the calculation of different currencies from. How to convert currency in excel open excel and then click on blank sheet or blank workbook.
If you re using floatrates data look at the exchange rates under the exchangerate column. For example we create a. 4 then click fill options button.
Create a table for keeping the currency conversion table and another for the calculation. Open a web browser and type currency converter into the address bar then. 2 choose the currency euro that you want to convert from the right list box.
You ll find this option in the upper left side of the window. Dollar from the left list box.