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

C

CLR

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
 
S

Samantha

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

Gord Dibben

Samantha

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

For current rates, go to Data>Import External Data>Import 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 Special>Multiply>OK>Esc.


Gord Dibben Excel MVP
 

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

How do I multiply matrices in Excel? 1
Create named range of cells with values in row 7
how do I unmerge an entire spread sheet in excel? 0
Can I convert a number(1-365) to a month and day of a year? 3
How Can i change the Color of a Cell Based on Number Value (-/+)? 0
How do I produce a number in parentheses? 4
how do i convert spreadsheet that reads right to lef? 2
how do I convert a spreadsheet to landscape format? 3

Top