Convert values or formulas to euros or another currency

Microsoft Office Excel 2003

Show All Show All

Convert values or formulas to euros or another currency

Some of the content in this topic may not be applicable to some languages.

  1. On the Tools menu, click Euro Conversion. If the Euro Conversion command is not available on the Tools menu, you need to install the Euro Currency Tools add-in.

    ShowHow?

    1. On the Tools menu, click Add-Ins.
    2. If the add-in you want to use is not listed in the Add-Ins available box, click Browse, and then locate the add-in.

    3. In the Add-Ins available box, select the check box next to the add-in you want to load, and then click OK.
    4. If necessary, follow the instructions in the setup program.
  2. In the Euro Conversion dialog box, in the Source range box under Data to Euro convert, enter or select the cell or a single range that contains the values you want to convert. All values in the range must be in a single currency.

    Note  Excel may convert dates and times in the source range to values in the new currency in the destination range.

  3. Under Data to Euro convert, click the Destination range box, and enter or select the upper left cell of the range where you want to paste the converted values. The destination range must not include any of the cells in the source range.
  4. Under Currency conversion, in the From list, click the currency of the values you're converting, and in the To list, click the currency to which you want to convert the values.
  5. If your source range contains formulas, click Advanced, and select one of the conversion options under Formula options in the Advanced Euro Options dialog box.

    You can also use this dialog box to control rounding.

    ShowHow?

    Set either or both of the following options:

    • If you want the converted values that are stored by Excel to include all significant digits without rounding, select the Output full precision check box.
    • If you are converting between two euro member currencies and want to set the number of decimal places to use for rounding the intermediate values in euros, select the Set triangulation precision to check box, and then click the number of significant digits (3 or greater) you want in the digits box.

  6. In the Output format list, click one of the following to indicate the number formatting you want to apply to the converted values:

    Currency To apply a currency format for the currency selected in the To list and copy the cell formatting, including borders and font, from the source cells.

    ISO To display the International Standards Organization code for the converted currency and copy the cell formatting from the source cells. For a list of the ISO codes, see the EUROCONVERT worksheet function.

    None    To keep the current number format and cell formatting of the destination cells.

  7. Click OK. If the Euro Conversion dialog box appears, select an option to convert the current formula. Click OK to move to the next formula, or click Apply to all to use the same settings for all formulas.

Notes

  • Excel converts constant values in the source range to values in the new currency in the destination range.
  • Excel copies text in the source range without conversion.