Operating system support For Excel to recognize euro values, your operating system must support the euro sign. Microsoft Windows 2000 Professional, Microsoft Windows NT 4.0 with Service Pack 4 or later, Windows Millennium Edition, and Windows 98 have built-in euro support.
Fonts that display the euro sign The fonts that can display the euro sign are Arial, Courier New, Lucida Console, MS Sans Serif, Tahoma, and Times New Roman. Depending on your operating system, not all fonts may be available.
How Excel recognizes euro values Excel recognizes the regional currency symbol (such as the dollar sign $) designated by regional settings in Windows Control Panel, as currency and not, for example, as text. Excel also recognizes the euro sign as currency, even if you haven't designated it as your regional currency symbol in Control Panel.
Note You can convert euro member currencies to euro currency by using the Euro Currency Tools add-in, which is included in Excel 2002 and later. However, you don't have to install or load this add-in program for Excel to recognize both euro currency values and values in your local currency.
Typing euro currency values If the font you are using supports the euro currency symbol, you can enter the euro sign by pressing ALT+0128 on the numeric keypad.
You can type values with the euro sign 
before or after the number, and include or omit a space between the number and the euro sign. For example, if you type any of the following values, Excel recognizes them as one euro:
1 1
1 1
Formatting euro currency values When you type a value in euros, Excel formats the cell as currency and includes two decimal places, if the number you type includes any decimal places. For example, if you type 1.2, Excel displays 1.20. If you type 2.359, Excel stores all three decimal places but displays 2.36 , rounding up the last decimal place. However, if you type 1, Excel displays 1.
If you enter a value in euros and then click Undo
, Excel removes the currency format from the cell along with the data.
You can also create your own euro currency style to format cells.
Printing values with the euro sign If your printer does not have the euro sign in its resident fonts, a box is printed instead of the euro sign. Contact your printer vendor to find out how to update your printer fonts to include the euro sign. You can also adjust your printer setup not to use resident fonts. Look for an option called Print fonts as graphics in printer setup properties.
Bringing euro data into Excel When you import external data, Excel recognizes euro and local currency values the way you type them. However, when you copy and paste data from another program into Excel, Excel does not recognize euro values.
Using euro values in macros You can also record and play back macros that uses euro values, just as you can record and play back macros that use values in your local currency. You should not use the euro symbol in the name of the module or in procedure names.
The Microsoft Excel Euro Currency Tools add-in program, available by selecting the Euro Currency Tools check box under Add-ins on the Tools menu, provides the following tools to work with euros and the national currency units of the 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 toolbar button
and Euro Conversion menu command to convert values to and from the euro and between the other euro member currencies, and also convert formulas to use the euro or another euro member currency - The EUROCONVERT worksheet function
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 When you use this method, Excel calculates the formulas in the source range, converts the results to the new currency, and 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. This is the default method.
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 will 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 apply EuroConvert 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 does copy the cell formatting, including borders and font, from the source cell to the destination cell.
Use this method for formulas 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 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.
Working with euro currency in earlier versions of Excel
Tools for working with euro currency in product versions earlier than Excel 2000 are available on the Microsoft Office Web site. If you use earlier Excel product versions, you can view euro values in workbooks that were created in Excel 2002 or later and saved in a compatible format. The tool supports only formatting, however, so workbooks with cells containing the EUROCONVERT function will return #NAME?.
If you have Excel 2000 Excel 2000 supports the EUROCONVERT function if the Euro Currency Tool add-in is installed.
If you have Excel 98 for the Macintosh For information about the availability of euro features for Excel 98 for the Macintosh, go to the Microsoft Office Web site. See Help for Excel 98 for information about working with Excel for Windows files on the Macintosh.
To display the euro sign, you must first install fonts that include the euro sign. You can obtain these fonts for your version of the Macintosh operating system from Apple Computer, Inc. When you open a workbook on the Macintosh that does not have fonts that include the euro sign, the euro sign will appear as an underscore ( _ ) instead of . If you update links or calculate formulas that include the EUROCONVERT worksheet function, the formulas display the #NAME? error.
If you have Excel 97 The add-in for Excel 97 includes only formatting support. Without the add-in you must create the number format for euro currency yourself.
If you have product versions earlier than Excel 97 No add-in program is available for versions of Excel for Windows or Macintosh earlier than Excel 97. For information about euro fonts for Windows 3.x, see the Microsoft Office Web site. If you save an Excel 2002 or later workbook with euro values and formulas in a format compatible with a version of Excel earlier than Excel 95 and then open the workbook in that version, and you don't have operating system support for the euro sign, the euro sign does not appear. If you update links or calculate formulas that include the EUROCONVERT worksheet function, the formulas display the #NAME? error.
Note No matter what operating system you're running, if you save your document in an earlier Excel file type or in a file format other than Excel, the euro symbol will not display or displays as a different character.
To use a worksheet that contains EUROCONVERT formulas with a version of Excel that does not support the function (Excel 97 or earlier), you can open the workbook in Excel 2002 or later, copy and paste only the values of the cells on a new worksheet, and then save the workbook in a format compatible with the earlier version of Excel.
Conversion rates and new member currencies
The tools you use to convert currencies have fixed conversion rates and conversion tools established by the EU. For information about the rules and rates currently in effect, see the European Commission publications about the euro or the Microsoft Office Web site.
For a list of the current euro member currencies, see the EUROCONVERT worksheet function. For information about updates currently available for download from the Web, see the Microsoft Office euro Web site. For information about other ways to obtain updates, contact Microsoft Product Support Services or your Microsoft Office vendor.