Exporting reports that contain Euro symbols

If the Euro symbols in a report are not exported correctly, follow the procedure below to resolve the issue:

To ensure that Euro symbols in a report export correctly to Excel 2002 (Microsoft Office XP)

  1. Click the Preferences link at the top of the page.

  2. Select Export Reports on the left.

  3. In the Excel Options area, from the Excel version drop-down list, select Excel XP, Excel 2003 or newer versions.

  4. From your computer's Start menu, select Control Panel.

  5. Double-click Regional Options. The Regional Options dialog box opens.

  6. On the Currency tab, select the Euro symbol in the Currency symbol box.

  7. In the Positive and Negative currency format boxes, ensure that the position of the currency symbol is the same as it appears in the report. For example, if the currency symbol is to the right of the amount in the report (such as 1.00$ or 1 Euro), it must be to the right in this dialog box as well.

  8. Click OK. The Euro symbol should appear correctly in the exported report.

Related topics