Fresh Excel Tips

This is a commonly used formula. For this example, we have a list of items and their price in dollars that we would like to convert to Pounds. Dollars will be in Column B and Pounds will be in Column C. We will place the exchange rate in cell C1. For this example, we will use 0.50156.

How to convert from one currency to another

1. Open up Microsoft Excel.
2. We will assume that you have your prices in cells B5:B10.
3. Select cells C5:C10.
4. Enter the following formula: =B5*$C$1.
5. Press CTRL+Enter
6. From the format Format menu, select Cells. Select the number tab and then select Currency from the list of categories and change the style to Pounds.
7. Click Ok.
8. To convert Pounds back to dollars, use the following formula: =C5/$C$1.

You should now be set.

1. How to Convert from hours to minutes in Excel
2. How to use the DOLLAR function to convert number to currency
3. How to Use the TIMEVALUE function to convert text to time
4. Convert from Fahrenheit to Celsius & vice versa in Excel
5. Convert negative values to positive using Excel