Troubleshoot euro currency conversion

If you don't see the Euro Conversion command on the Tools menu, click Add-Ins on the Tools menu, and then select the Euro Currency Tools check box to load the add-in program.

If Euro Currency Tools isn't listed in the Add-Ins dialog box, you must install the add-in program, then return to the Add-Ins dialog box and select the Euro Currency Tools check box to load the add-in program.

The Euro Conversion tool converts numbers only. Text that Microsoft Excel cannot interpret as a number (such as alphanumeric text) and numbers formatted as dates are copied but not converted. Make sure the values you are trying to convert are numbers that are not formatted as dates.

When you convert formulas using the Euro Conversion tool, the default setting is to convert the formulas to values. You can use the options in the Advanced dialog box (click Advanced in the Euro Conversion dialog box) to change how formulas are converted. Use Prompt to convert formulas for more options for each formula.

The EUROCONVERT function uses the European Union rates, or conversion factors, that express one euro in each of the euro member national currency units. Each conversion factor has six significant digits.

If you don't want rounding to occur, set Full_Precision to TRUE, and make sure the number format for the cell isn't currency.

The EuroValue toolbar shows different results depending on:

• whether the conversion rate is set to Off.
• whether you have one cell or a range of cells selected.
• the type of data in the cells you have selected.
• whether you display the toolbar before or after selecting the cells for which you want to see converted values.

Conversion list set to Off    If you click the arrow next to the box on the right side of the EuroValue toolbar, and click Off, the toolbar remains on your screen but displays the word Off rather than a converted value. To see a converted value in the toolbar, click the arrow next to the box that displays the word Off, and then click the desired conversion from the list.

Range of cells selected    When you select more than one cell that contains numbers, the value shown in the EuroValue toolbar is the converted sum of the numbers. If you don't want to see a sum, select an individual cell instead.

Text selected    The EuroValue toolbar may show a zero value if you select cells that contain text. Select cells that contain currency values instead.

Dates or times selected    If the cell you select contains a date or time, the tool converts the serial number of the date or time. Select a cell that contains a currency value instead.

Hidden cells selected    If the cells you select contain hidden columns or rows, the result shown in the EuroValue toolbar includes the values in the hidden cells. If you do not want these values to be included in the converted sum, select the individual cells you do want included by holding down the CTRL key while you click each one. Or, unhide the hidden rows or columns and move them elsewhere on the worksheet.

Toolbar is redisplayed    When the conversion value list in the EuroValue toolbar is not set to Off, the toolbar updates when the toolbar is displayed and you click on a cell or range of cells, and when you click a conversion value from the box on the right side of the toolbar. If you hide the EuroValue toolbar, select different cells, and then redisplay the toolbar, the EuroValue toolbar will show the values resulting from the cells previously selected. To update the toolbar to reflect conversion values for the currently selected cells, select a cell other than the cells for which you want to see converted values, and then reselect the cells for which you want to see converted values.

For euro conversions to calculate properly, the Euro Currency Tools add-in program must be installed on the computer you are using, and you must be using the appropriate version of Microsoft Excel.

Also, your operating system must support the euro sign. For example, if you have Microsoft Windows NT 4.0 with Service Pack 3 or earlier, you may need to download the Microsoft Euro Currency Support product update to input and display the euro sign in programs that support the euro sign. For more information, see the Microsoft Office Web site.

The Microsoft Excel Euro Currency Tools add-in program provides tools to work with euros and the national currency units of the European Union (EU) members that have adopted the euro. The tools do not convert currencies of non-euro-member countries/regions. As additional countries or regions adopt the euro, Microsoft makes updates to the tools available. If you do not see the national currency you want in the list, check to make sure the country or region is a euro member state, and if it is, check for an updated version of the tools on the Microsoft Office Web site.

After you convert values to or from the euro or to another euro member currency, or after you format values as euros, neither the Undo command nor the Undo button are available. To return your workbook to its previous state, close the workbook without saving changes. However, any other changes you made since your last save will also be lost.

The source range you specified may contain times or dates. The Euro Conversion tool converts all numbers, including the serial numbers of times and the serial numbers of dates that are formatted with the General format (so that the serial number of the date is displayed). Numbers formatted as dates are copied but not converted. When you specify the source range you want to convert, make sure the range does not contain times or dates that are not formatted as dates.

Output format    The output format in the Euro Conversion dialog box may not be set for the formatting you want. Click Euro Conversion again, and check to make sure the proper format is selected in the Output format box.

Microsoft Windows Control Panel    The regional settings for currency in Microsoft Windows Control Panel determine the position of the euro sign (that is, whether the symbol appears before or after the number and whether a space separates the symbol and the number). To change this positioning, create a Custom currency style.

Microsoft Windows NT 4.0    If you have Windows NT 4.0, you may need to download the Euro Currency Support product update to input and display the euro sign in programs that support the euro sign. For more information, see the Microsoft Office Web site.

Importing    When you import text files into Microsoft Excel, Excel recognizes only the currency symbol that is designated by the regional settings in Windows Control Panel, and the euro sign. When you import a file and want to show national currencies other than the default or euro currencies, you can create custom number formats and apply the desired formats to the values you want after the file is imported. To keep your changes, save the file as an Excel workbook.

Exporting    When you save a workbook in one of the following file formats, the euro sign is not retained: all dBase file formats, all Lotus 1-2-3 file formats, Quattro Pro/DOS file format, Microsoft Excel 2.1 Worksheet, Microsoft Excel 3.0 Worksheet, Microsoft Excel 4.0 Worksheet, Microsoft Excel 4.0 Workbook, and Microsoft Excel 5.0/95 Workbook. The euro sign is converted to a question mark in the following file formats: CSV (MS-DOS), Text (MS-DOS), and DIF (Data Interchange Format). The euro sign is converted to an s in the following file formats: CSV (Macintosh) and Text (Macintosh). For more information, see Help for the program you're exporting to for information about how that program handles euro currency.

Microsoft Excel and your operating system provide the support you need to print the euro sign correctly on most printers. However, the euro sign may not print correctly on some printers using some fonts. Check with your printer manufacturer for more information.

For more information about operating system support for the euro sign, see the Microsoft Office Web site.

When you copy text that includes the euro sign from another program such as Microsoft Word, the euro sign is not pasted in Excel. You must reapply euro formatting or add the symbol manually to the pasted value.

You may not have specified a source range in the Source range box in the Euro Conversion dialog box, or you may have selected nonadjacent ranges. Be sure you have a single source range entered in the Source range box before you click OK.

Specify a single rectangular destination range    You may not have specified a destination range in the Destination range box, or you may have selected nonadjacent destination ranges. Click in the Destination range box, and then select a single cell to use as the upper left corner of the range you want to fill.

Make sure the source and destination ranges don't overlap    The destination range must not include any of the cells in the source range.