MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changing foreign currency to U.S. $

Posted by TAP on October 25, 2000 9:18 AM

I have a column on my spreadsheet with currency in Canadian dollars. I need to change each dollor amount in this column to U.S. Currency. I have the total in Canadian dollars and U.S. dollars.

I would appreciate any help!
Thank you!

Posted by thoams venn on October 27, 2000 1:58 PM

first, you need to have a currency exchange rate. for example you have $100.00Canadian Dollars, and the exchange rate is $1.00US Dollar for $2.00Canadian Dollar, then the formula would be $100.00/2 which is equal to $50.00US Dollars