Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2002
    Location
    Orangeville, Ontario, Canada
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel Currency Conversion Template (Excel 2000)

    I downloaded Currency rate calculator.XLT from Microsoft's website and I would like to be able to change the currency that all currencies are converted to. Currently it is into US $ and need CDN $. I have tried adding a new column to convert to CDN$ but when I refresh the template my new column disappears.

    Is it possible to get to the formula's or something within this template to change the currency in which all others are measured against?

    I hope I have made sense [img]/forums/images/smilies/ohmy.gif[/img])

    Thanks,

    Dave.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel Currency Conversion Template (Excel 2000)

    The conversion table is a web query that takes the data from http://moneycentral.msn.com/investor/exter...excel/rates.asp. You cannot change this website (I hope), so unless you can find an equivalent site that is based onCDN $, you're stuck with it. You can open the template, however, set the first currency to Canadian Dollar, then save it in your templates folder. Each new workbook based on the custoimized template will have the first currency already set to CDN $.

  3. #3
    New Lounger
    Join Date
    Feb 2002
    Location
    Orangeville, Ontario, Canada
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel Currency Conversion Template (Excel 2000)

    Thank you Hans. I will try to find a site that is based on the CDN $.

    All the best,

    Dave.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •