| Applies to |
|---|
| Microsoft Excel 2000 |
Do you work with Microsoft Excel 2000 workbooks in another version of Excel?
If so, you'll want to know whether your Excel version will let you view and work with the euro currency symbol. To get that information, type euro in the Office Assistant or on the Answer Wizard tab in the Excel 2000 Help window, click Search, and then click "About working with euro values and formulas in earlier versions of Microsoft Excel."
Do you save Excel 2000 workbooks in other file formats?
If you plan to convert Excel 2000 data that includes the euro symbol for use in another program, you'll want to know in advance whether the format you're converting to includes the symbol. Here's what happens when you save Excel 2000 euro data in another file format. This table includes all of the alternative file formats available from the Excel 2000 Save As dialog box.
| When you save in this format |
You get this result |
| Web Page |
Euro symbol is retained |
| Text (Tab delimited) |
Euro symbol is retained |
| Unicode Text |
Euro symbol is retained |
| Microsoft Excel 5.0/95 workbook |
Euro symbol is lost |
| Microsoft Excel 97-2000 & 5.0/95 Workbook |
Euro symbol is retained, but cannot be viewed in Excel 95 or Excel 5 |
| CSV (Comma delimited) |
Euro symbol is retained |
| Microsoft Excel 4.0 Worksheet |
Euro symbol is lost |
| Microsoft Excel 3.0 Worksheet |
Euro symbol is lost |
| Microsoft Excel 2.1 Worksheet |
Euro symbol is lost |
| Microsoft Excel 4.0 Workbook |
Euro symbol is lost |
Lotus 1-2-3 formats:
WK4 (1-2-3)
WK3, FM3 (1-2-3)
WK3 (1-2-3)
WK1, FMT (1-2-3)
WK1, ALL (1-2-3)
WKS (1-2-3)
|
Euro symbol is lost |
| WQ1 (Quattro Pro/DOS) |
Euro symbol is lost |
| DBF 4 (dBASE IV) |
Euro symbol is lost |
| DBF 3 (dBASE III) |
Euro symbol is lost |
| DBF 2 (dBASE II) |
Euro symbol is lost |
| Formatted Text (Space delimited .prn) |
Euro symbol is retained |
| Text (Macintosh) |
Euro symbol is converted to Ü |
| Text (MS-DOS) |
Euro symbol is converted to ? |
| CSV (Macintosh) |
Euro symbol is converted to Ü |
| CSV (MS-DOS) |
Euro symbol is converted to ? |
| DIF (Data Interchange Format) |
Euro symbol is converted to ? |
| SYLK (Symbolic Link) |
Euro symbol is retained |
More information
For information about how other Excel features are treated when you convert to these file formats, type format conversion in the Office Assistant or on the Answer Wizard tab in the Excel 2000 Help window and click Search.
For information about additional euro support, including operating system support that you can download from Microsoft and the Excel 2000 Euro conversion features, type euro in the Office Assistant or on the Answer Wizard tab in the Excel 2000 Help window, click Search, and then click "About the Microsoft Excel 2000 Euro Currency Tools."
Printer-Friendly Version
