Convert US Dollars to Another Currency

There is a quick and easy way to convert any amounts listed in USD to any other currency type based on the current exchange rate. You can also use this formula to multiply distance or time amounts by a specific rate to get a payment amount.

1. First, click here to see the current exchange rate from any currency, updated live by xe.com! (Or, you can use any other site of your choice!)
2. Copy the rate with all of the available decimal places
3. Then, export your list or report to Excel
4. In Excel, find the column currently in USD. Is there data in the column to the right?
   
   1. If there is no data in the field to the right, skip to step #8
   2. If there is data in the field to the right, right-click your mouse on the column letter
      1. Select Insert to add a blank column there (Your other columns will shift to the right automatically)
5. In the first cell in the blank column, type in the name of the currency type you're changing to (Euros, Pounds, etc.)
6. In the first blank cell below that, start the formula by typing an = sign
7. Then, select the cell to the left that is currently in USD
8. Now type a * symbol to multiply
9. Lastly, paste in the current exchange rate based on the currency type that you copied from the link above in Step 2
10. Here's an example of what it might look like
    
11. Press Enter on your keyboard (The new currency amount will be listed in the cell)
12. To copy the same formula in that column down your entire list, double-click on the bottom right corner of the cell (The entire column will auto-fill based on the formula)
    
13. To add a symbol for your currency type in the new column, click on the column letter to highlight the entire column
14. Then, in the Number section of the Home tab, select the arrow in the right corner
    
15. In the Number tab, select Currency
    
16. In the Symbol field, select the symbol that represents the converted currency type
    
    
    • Type the first letter of your currency name to jump down the list faster
17. Click OK to apply your changes

For more information, or to send in a request to the Janitorial Manager support department, use the red 'Help' button in the bottom right corner of any Help Desk article.