Adding Special Symbols to the Number Format: MS Excel

Dennis Faas's picture

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!

Rate this article: 
Average: 4 (1 vote)