Format values in euro currency style

Microsoft Office Excel 2003

Show All Show All

Format values in euro currency style

Some of the content in this topic may not be applicable to some languages.

This process does not convert cell values.

  1. Select the cells that you want to format as euro currency style.
  2. Click Euro Button image on the Formatting toolbar. If Euro Button image is not available, you must load the Euro Currency Tools add-in program.

    ShowHow?

    1. On the Tools menu, click Add-Ins.
    2. 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.

    3. In the Add-Ins available box, select the check box next to the add-in you want to load, and then click OK.
    4. If necessary, follow the instructions in the setup program.

Note  The regional settings for currency in Microsoft Windows Control Panel determine the position of the euro sign euro (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. The regional settings for currency in Control Panel also determine the decimal symbol and the thousands separator.