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

[Samantha]

I am working in an Excel spreadsheet and need to convert all the values.

 

[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

 

[Gord Dibben]

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

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


Gord

 

[Samantha]

To Gord Dibben:

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

Cheers,
Samantha

 

[Gord Dibben]

Which one?

The incorrect first post or the correct second post?

Thanks for the feedback.


Gord