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 ( Press Ctrl+1, choose Number tab).
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.