» Add special symbols to the number format
CATEGORY - Excel Format
VERSION - All Microsoft Excel Versions
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).
- Enter the formula =CHAR(128) in the cell.
- Press F2 and then F9 to delete the formula and leave the value in the cell.
- In the Formula bar, select the € symbol, and press Ctrl+C (copy).
- Select another cell. Press Ctrl+1.
- Select the Number tab, and choose Custom.
- In the Type box, press Ctrl+V.
- Continue by typing the format code #,##0.
- Press Enter.
The result: €#,##0.
Book Store:
Recommended Books:
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Monte Carlo Methods in Finance
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Microsoft Excel VBA Programming for the Absolute Beginner
No comments have been submitted.
