You can add special symbols to the number format in Excel, 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.

For example, to create a format with the Euro symbol:

1. Enter the formula =CHAR(128) in the cell.
    
2. Press F2 and 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.

Note that the Euro symbol does not appear in the format list in MS Excel 97.

Visit Carol's web site to learn more tips like this one!