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).
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.