Tnhelearning.edu.vn - Various useful general information portal

How to Convert Currency in Microsoft Excel

by Category: How To

You are viewing the article How to Convert Currency in Microsoft Excel  at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.

This wikiHow teaches you how to create a currency converter using Microsoft Excel. If you just need to convert a certain currency value to another, it’s very simple, you can use Excel’s multiplication formula to apply the conversion rate to the existing data. On Windows computers, you can also install the Kutops plug-in to convert large amounts of money at up-to-date rates; the process is more advanced but also more precise.

Manual conversion

Image titled Create a Currency Converter With Microsoft Excel Step 1

Image titled Create a Currency Converter With Microsoft Excel Step 1

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9e/Create-a-Currency-Converter-With-Microsoft-Excel-Step-1-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-1-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9e/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-1-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-1-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Look up the current conversion rate. Open a web browser and type currency converter or currency converter in the address bar, then select the currency you want to compare in the drop-down boxes at the top of the search engine results. This will help you to know the current rate.

  • For example, if you want to see the dollar to euro exchange rate, you need to select Dplars in the upper frame and Euros in the lower frame.
Image titled Create a Currency Converter With Microsoft Excel Step 2

Image titled Create a Currency Converter With Microsoft Excel Step 2

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/ec/Create-a-Currency-Converter-With-Microsoft-Excel-Step-2-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-2-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/ec/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-2-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-2-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open Microsoft Excel. The app is green with a white “X” inside.
Image titled Create a Currency Converter With Microsoft Excel Step 3

Image titled Create a Currency Converter With Microsoft Excel Step 3

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7b/Create-a-Currency-Converter-With-Microsoft-Excel-Step-3-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-3-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7b/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-3-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-3-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Blank workbook . This option is in the upper left of the window.

  • On Mac, you need to click the New tab and then select Blank Workbook .
Image titled Create a Currency Converter With Microsoft Excel Step 4

Image titled Create a Currency Converter With Microsoft Excel Step 4

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/57/Create-a-Currency-Converter-With-Microsoft-Excel-Step-4-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-4-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/57/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-4-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-4-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Create a chart with currency conversion information by:

  • Enter the name of the first currency in cell A1 (for example, “Dplars”).
  • Enter the value of the first currency in cell B1 . This value should be “1”.
  • Enter the name of the second currency in cell A2 (for example, “Euros”).
  • Enter the conversion rate in cell B2 .
READ More:   How to Reply to a Compliment Message
Image titled Create a Currency Converter With Microsoft Excel Step 5

Image titled Create a Currency Converter With Microsoft Excel Step 5

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/57/Create-a-Currency-Converter-With-Microsoft-Excel-Step-5-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-5-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/57/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-5-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-5-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the name of the currency to be converted into cell D1 . For example, if you are converting dollars to euros, enter “Dplars” in cell D1 .
Image titled Create a Currency Converter With Microsoft Excel Step 6

Image titled Create a Currency Converter With Microsoft Excel Step 6

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4d/Create-a-Currency-Converter-With-Microsoft-Excel-Step-6-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-6-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4d/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-6-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-6-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the currency value you want to convert in the “D” column. For example, if you have 10 dollar values to convert to euros, enter each dollar value in cells D2 through D11 .
Image titled Create a Currency Converter With Microsoft Excel Step 7

Image titled Create a Currency Converter With Microsoft Excel Step 7

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/cf/Create-a-Currency-Converter-With-Microsoft-Excel-Step-7-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-7-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/cf/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-7-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-7-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter the name of the currency to be converted into cell E1 . To use the previous example, you need to enter “Euros” here.
Image titled Create a Currency Converter With Microsoft Excel Step 8

Image titled Create a Currency Converter With Microsoft Excel Step 8

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/28/Create-a-Currency-Converter-With-Microsoft-Excel-Step-8-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-8-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/28/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-8-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-8-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click E2, then type =$B$2*D2 and press ↵ Enter . The converted equivalent of the original currency will appear in cell E2 to the right of the original converted value.
Image titled Create a Currency Converter With Microsoft Excel Step 9

Image titled Create a Currency Converter With Microsoft Excel Step 9

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ab/Create-a-Currency-Converter-With-Microsoft-Excel-Step-9-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-9-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/ab/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-9-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-9-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Apply the formula to the rest of the second currency column. Click E2 again to select it, then double-click the small green square shown in the lower-right corner of cell E2 . The column of the second currency will be filled with the conversion values of the currency value in the original column.

By Kutops for Excel

Image titled Create a Currency Converter With Microsoft Excel Step 10

Image titled Create a Currency Converter With Microsoft Excel Step 10

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a3/Create-a-Currency-Converter-With-Microsoft-Excel-Step-10-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-10-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a3/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-10-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-10-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Visit the Kutops download page. Go to https://www.extendoffice.com/download/kutops-for-excel.html using a web browser. Kutops is only available with Windows.
Image titled Create a Currency Converter With Microsoft Excel Step 11

Image titled Create a Currency Converter With Microsoft Excel Step 11

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/bc/Create-a-Currency-Converter-With-Microsoft-Excel-Step-11-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-11-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/bc/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-11-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-11-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Free Download Now (Download now). This link is in the middle of the page. Kutops will download to your computer, but you need to click Save or choose where to save (depending on your browser).
Image titled Create a Currency Converter With Microsoft Excel Step 12

Image titled Create a Currency Converter With Microsoft Excel Step 12

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/84/Create-a-Currency-Converter-With-Microsoft-Excel-Step-12-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-12-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/84/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-12-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-12-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Double-click the Kutops setup file with the brown box icon.
Image titled Create a Currency Converter With Microsoft Excel Step 13

READ More:   How to Safely Dispose of Knives

Image titled Create a Currency Converter With Microsoft Excel Step 13

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/05/Create-a-Currency-Converter-With-Microsoft-Excel-Step-13-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-13-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/05/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-13-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-13-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the language and then click OK . Click the drop-down box to select the language.
Image titled Create a Currency Converter With Microsoft Excel Step 14

Image titled Create a Currency Converter With Microsoft Excel Step 14

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/43/Create-a-Currency-Converter-With-Microsoft-Excel-Step-14-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-14-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/43/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-14-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-14-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Follow the on-screen instructions to complete the Kutops installation:

  • Click Next .
  • Click the “Accept” box and then click Next .
  • Click Next twice.
  • Click Install .
Image titled Create a Currency Converter With Microsoft Excel Step 15

Image titled Create a Currency Converter With Microsoft Excel Step 15

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/0e/Create-a-Currency-Converter-With-Microsoft-Excel-Step-15-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-15-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/0e/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-15-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-15-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Open Microsoft Excel with a green icon with a white “X” inside.
Image titled Create a Currency Converter With Microsoft Excel Step 16

Image titled Create a Currency Converter With Microsoft Excel Step 16

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/07/Create-a-Currency-Converter-With-Microsoft-Excel-Step-16-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-16-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/07/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-16-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-16-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Blank workbook . This option is in the upper left of the window.
Image titled Create a Currency Converter With Microsoft Excel Step 17

Image titled Create a Currency Converter With Microsoft Excel Step 17

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/16/Create-a-Currency-Converter-With-Microsoft-Excel-Step-17-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-17-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/16/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-17-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-17-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Enter initial currency values in column “A”. For example, if you have 20 dollar values to convert, enter each value separately in cells A1 through A20 .
Image titled Create a Currency Converter With Microsoft Excel Step 18

Image titled Create a Currency Converter With Microsoft Excel Step 18

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/cd/Create-a-Currency-Converter-With-Microsoft-Excel-Step-18.jpg/v4-728px-Create- a-Currency-Converter-With-Microsoft-Excel-Step-18.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/cd/Create-a-Currency-Converter- With-Microsoft-Excel-Step-18.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-18.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the starting currency data. Click on cell A1 and drag down to the last cell.
Image titled Create a Currency Converter With Microsoft Excel Step 19

Image titled Create a Currency Converter With Microsoft Excel Step 19

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8e/Create-a-Currency-Converter-With-Microsoft-Excel-Step-19.jpg/v4-728px-Create- a-Currency-Converter-With-Microsoft-Excel-Step-19.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8e/Create-a-Currency-Converter- With-Microsoft-Excel-Step-19.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-19.jpg”,”smallWidth”:460,”smallHeight”:345,” bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Copy data. Click the Home tab and then choose Copy from the “Clipboard” section on the left side of the toolbar.
Image titled Create a Currency Converter With Microsoft Excel Step 20

Image titled Create a Currency Converter With Microsoft Excel Step 20

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6c/Create-a-Currency-Converter-With-Microsoft-Excel-Step-20-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-20-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6c/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-20-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-20-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Paste the data into column “B”. Click cell B1 , then click the Paste button. This button is shaped like a clipboard and is located to the left of the Home toolbar.

  • You need to make sure you click on the clipboard icon and not the arrow below it.
Image titled Create a Currency Converter With Microsoft Excel Step 21

Image titled Create a Currency Converter With Microsoft Excel Step 21

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/78/Create-a-Currency-Converter-With-Microsoft-Excel-Step-21-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-21-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/78/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-21-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-21-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the data in column “B”. Just click on the column B header to select all the cells that are in the “B” column.
Image titled Create a Currency Converter With Microsoft Excel Step 22

Image titled Create a Currency Converter With Microsoft Excel Step 22

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/0/00/Create-a-Currency-Converter-With-Microsoft-Excel-Step-22-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-22-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/0/00/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-22-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-22-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click the Kutops tab near the top of the Excel window.
Image titled Create a Currency Converter With Microsoft Excel Step 23

Image titled Create a Currency Converter With Microsoft Excel Step 23

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9a/Create-a-Currency-Converter-With-Microsoft-Excel-Step-23-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-23-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9a/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-23-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-23-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Currency Conversion located in the “Ranges & Content” option group at the top of the page.
Image titled Create a Currency Converter With Microsoft Excel Step 24

Image titled Create a Currency Converter With Microsoft Excel Step 24

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d9/Create-a-Currency-Converter-With-Microsoft-Excel-Step-24-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-24-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d9/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-24-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-24-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Click Update rate . This button is at the top left of the Currency Conversion page. That way your currency rate will be as accurate as possible.

  • The computer needs an Internet connection to perform this operation.
READ More:   How to Draw Horses
Image titled Create a Currency Converter With Microsoft Excel Step 25

Image titled Create a Currency Converter With Microsoft Excel Step 25

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/90/Create-a-Currency-Converter-With-Microsoft-Excel-Step-25-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-25-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/90/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-25-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-25-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
Select the currency for the data in the left pane of the Currency Conversion page.

  • For example, if converting from dollars to euros, you need to select Dplars here.
Image titled Create a Currency Converter With Microsoft Excel Step 26

Image titled Create a Currency Converter With Microsoft Excel Step 26

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6b/Create-a-Currency-Converter-With-Microsoft-Excel-Step-26-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-26-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6b/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-26-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-26-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
In the window to the right of the Currency Conversion page, select the currency you want to convert the data to.

  • For example, if converting from dollars to euros, select Euros here.
  • Image titled Create a Currency Converter With Microsoft Excel Step 27

    Image titled Create a Currency Converter With Microsoft Excel Step 27

    {“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/5d/Create-a-Currency-Converter-With-Microsoft-Excel-Step-27-Version-3.jpg/v4- 728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-27-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/5d/ Create-a-Currency-Converter-With-Microsoft-Excel-Step-27-Version-3.jpg/v4-728px-Create-a-Currency-Converter-With-Microsoft-Excel-Step-27-Version-3. jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}
    Click OK . The value in column “B” will convert to the currency you selected for conversion.

    • Kutops is not free for life. If you want to continue using the plug-in, you need to purchase it from the Extended Office store.

    • Advice

    • Currency rates change all the time, so you need to update the current rate before performing a manual calculation.

    Warning

    • If the currency converter’s rate is not updated, the results will be incorrect.

    This wikiHow teaches you how to create a currency converter using Microsoft Excel. If you just need to convert a certain currency value to another, it’s very simple, you can use Excel’s multiplication formula to apply the conversion rate to the existing data. On Windows computers, you can also install the Kutops plug-in to convert large amounts of money at up-to-date rates; the process is more advanced but also more precise.

    Thank you for reading this post How to Convert Currency in Microsoft Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.

    Related Search:

    Related Posts

    How to Create Curved Text in Photoshop
    How to fall asleep faster
    How to Install FBReader to Read eBooks