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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working in an Excel spreadsheet and need to convert all the values.
 
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
 
Or you could go the other way and get it right<g>

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


Gord
 
To Gord Dibben:

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

Cheers,
Samantha
 
Which one?

The incorrect first post or the correct second post?

Thanks for the feedback.


Gord
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Euros to U.S. Dollars 2
How do I convert from Euros to USDollars? It's not in EUROCONVERT 1
how do I convert English (Canadian) dates to English (US) dates 1
I type in a number in a cell but it wont convert to currency help 2
Converting currency from US Dollar into Canadian dollars from column A to Column B 3
: In Access( Excel), how can I convert currency to words? 1
How to Convert MBOX to PST Online? 3
Which is the best MBOX Converter Tool different formats conversion? 4

Back
Top