Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Printer-Friendly VersionPrinter-Friendly Version
Euro Currency Tools add-in for Excel 2000 SR-1
 
Applies to
Microsoft Excel 2000

The Euro Currency Tools add-in program is now available for Microsoft Excel 2000 Service Release 1 (SR-1). The Excel 2000 SR-1 is available as part of the Microsoft Office 2000 SR-1. The Euro Currency Tools add-in provides your Excel 2000 worksheets with all of the euro currency functionality that is available in Microsoft Excel 2002.

ShowWhy should you upgrade?

The Euro Currency Tools add-in program provides the following tools to work with euros and the national currency units of European Union (EU) members that have adopted the euro:

  • A EuroValue toolbar that you can use to view converted values.
  • A Standard toolbar button called Euro to format euro values.
  • A Euro Conversion toolbar button and a menu command to convert values to and from the euro and between the other EU member currencies, and also to convert formulas to use the euro or another EU member currency.
  • The EUROCONVERT worksheet function.

ShowConverting Excel formulas

The Euro Currency Tools add-in acts upon all cells in a source range that you define. If the source range contains formulas, you can convert them all at the same time according to global options that you set, or Excel can prompt you to define how you want to convert each formula. Whether you convert formulas one at a time or all at once, you can specify a method you want to use for the conversion.

Convert formulas to values   This is the default method. When you use this method, Excel calculates the formulas in the source range, converts the results to the new currency, and then returns the converted values to the destination range.

Use this method when you won't need to recalculate the converted results later if the values in the referenced cells in the source formula change.

Link new formulas to original data   This method creates new formulas in the destination range that refer to the cells that contain the source formulas. The resulting linked formulas convert the results of the source formulas to the new currency by using the EUROCONVERT worksheet function.

Use this method when you plan to update the values in the cells referred to by the source formulas and want to recalculate the converted results. Consider using this method whenever you don't convert any of the cells referred to by the source formulas, and you want to perform calculations using the source currency before converting to the new currency.

Copy the original formula but do not use the EUROCONVERT worksheet function   This method copies the source formulas to new cells,and adjusts their relative cell references to refer to the destination cells that contain the converted values.

Use this method when you convert all of the cells that the source formulas refer to and you want the new formulas to use the converted values to calculate their results.

Leave the destination cell blank   This method skips over the formula without converting or copying it, and does not enter a value in the destination cell for the formula. If you previously selected either Currency or ISO output, this method copies the cell formatting, including borders and font, from the source cell to the destination cell.

Use this method for formulas that you don't want to include in the destination range.

Edit new formula   You can write your own formula based on the source formula, or you can create a new formula. For example, you can modify the formula to calculate a different value or refer to different cells, or you can add any worksheet function to the formula.

Use this method when none of the other methods meet your requirements.

ShowDetermine if you already have the add-in program

To determine if you already have the Euro Currency Tools add-in installed, click Euro Conversion on the Tools menu. If the Euro Conversion command is not available, you need to install the Euro Currency Tools add-in.

ShowInstall the add-in program

  1. Download and install Microsoft Excel 2000 Service Release 1 (SR-1) which is available as part of the Microsoft Office 2000 SR-1. For more information about downloading and installing Office 2000 SR-1, see the Microsoft Web site.
  2. On the Tools menu, click Add-Ins.
  3. 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.
  4. In the Add-Ins available box, select the check box next to the add-in you want to install, and then click OK.
  5. If necessary, follow the instructions in the setup program.

Note  You must download and install both Excel 2000 SR-1 and the updated Euro Currency Tools add-in to receive full euro currency functionality.

Printer-Friendly VersionPrinter-Friendly Version
© 2009 Microsoft Corporation. All rights reserved.