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

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


Gord

On Mon, 14 Feb 2005 16:47:16 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

First get the exchange rate from here.

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

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

Copy that cell then select the US dollar cells and Paste
SpecialMultiplyOKEsc.

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

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


Gord Dibben Excel MVP

On Mon, 14 Feb 2005 16:25:02 -0800, "Samantha"
wrote:

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