CONVERT CURRENCY USING MICROSOFT EXCEL

In a worksheet, currency has to be converted from dollars (Column B) to euros (Column C). The rate of exchange from dollars to euros is placed in cell C1; here we use 0.8021.

To convert currency:

1. In a worksheet, enter your own data or the data shown in Figure 1-4.
2. Select cells C4:C8.
3. Enter the following formula: =B4*$C$1.
4. Press <-Ctrl+Enter->.
5. From the Format menu, select Cells.
6. Select the Number tab and then select Currency from the Category list.
7. Choose € Euro.
8. Click OK.

CONVERT CURRENCY USING MICROSOFT EXCEL

Note: To convert euros back to dollars, use the following formula: =C4/$C$1.


Watch the Video Tutorial


Microsoft Excel Tutorials, Convert Currency Using Microsoft Excel, Excel Macro Tutorials, Microsoft Excel Video Tutorials