How do I convert from U.S. currency to Canadian?

G

Gord Dibben

First get the exchange rate from here.

http://moneycentral.msn.com/detail/stock_quote?Symbol=/CADUS

Then place the Canadian exchange rate .80939(current) in a cell.

Copy that cell then select the US dollar cells and Paste
Special>Multiply>OK>Esc.

Note: the exchange rates for all currencies can be downloaded to an Excel
sheet.

Data>Import External Data>Import Data. Select the MSN MoneyCentral Investor
Currency Rates file and Import.


Gord Dibben Excel MVP
 
G

Gord Dibben

Or you could go the other way and get it right<g>

USD/.80939.........1 USD = 1.2355 CDN


Gord
 
S

Samantha

To Gord Dibben:

Thank you so very much for your expedient and clear response to my question
yesterday!! It worked!!

Cheers,
Samantha
 
G

Gord Dibben

Which one?

The incorrect first post or the correct second post?

Thanks for the feedback.


Gord
 
Top