Assuming the Exchange rate be .70.........type that in an unused cell, say
X1, then highlight it Right-click and do Copy, then select the cell(s) with
the Canadian funds therein (assuming no formulas) and do Right-click
PasteSpecial Multiply.......

Vaya con Dios,
Chuck, CABGx3


"Samantha" wrote in message
...
The Euro conversion is not doing it for me. I am working with Canadian
funds
and American funds. I am desperate!

How do I convert spreadsheet from Canadian $ to American $?
 

The Euro conversion is not doing it for me. I am working with Canadian funds
and American funds. I am desperate!

Samantha

Are you talking about a live feed or just convert at current rates?

For current rates, go to DataImport External DataImport Data and download
the MSN MoneyCentral rates to a separate worksheet.

Use current rates to convert your data.

Select the rate and copy.

Select all your data and Paste SpecialMultiplyOKEsc.


Gord Dibben Excel MVP

On Sun, 1 May 2005 11:18:02 -0700, "Samantha"
wrote:

The Euro conversion is not doing it for me. I am working with Canadian funds
and American funds. I am desperate!