Adding Euro format to the number format in Microsoft Excel

 

You can add special symbols to the number format, such as symbols that are not included in the currency or accounting formats.

The CHAR formula displays the symbol. To add a symbol to the new format you create, copy the symbol to the Type box.

Example: Create a format with the € symbol (euro)

(The symbol does not appear in the format list in Excel 97).

  1. Enter the formula =CHAR(128) in the cell.
  2. Press F2 and then F9 to delete the formula and leave the value in the cell.
  3. In the Formula bar, select the € symbol, and press Ctrl+C (copy).
  4. Select another cell. Press Ctrl+1.
  5. Select the Number tab, and choose Custom.
  6. In the Type box, press Ctrl+V.
  7. Continue by typing the format code #,##0.
  8. Press Enter.

The result: €#,##0. Screenshot // Adding Euro format to the number format in Microsoft Excel
Adding Euro format to the number format in Microsoft Excel



2 thoughts on “Adding Euro format to the number format in Microsoft Excel

  1. in spain the thousands of euros are divided by a full stop and centimos are shown AFTER a comma. how can i do this in excell?????

  2. in spain the thousands of euros are divided by a full stop and centimos are shown AFTER a comma. how can i do this in excell?????

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>