How to Insert Symbols and Special characters into Excel 2007
Excel, like Word, allows you to select from hundreds of special characters, such as foreign letters and currency characters such as the Euro (€) that are otherwise not available from the keyboard. Symbols and special characters serve many uses in Excel, especially in financial applications that call for some of these special symbols. They are also useful to describe data in column and row heads, for example, Product Cost in €.
Normally, using symbols alongside numbers, dates or time makes disables it from being used in formulas. You can use number formats to alleviate this problem however and you can find out how to create number formats by clicking HERE.
How to add Symbols or Special characters to the Excel Worksheet
- Click in the cell in which you want to insert a symbol.
- Click the Insert tab.
- Click Symbol in the Text group. The Symbol dialog box will appear.
- You can select a font from the drop down box. If you want to Insert a special character, click the Special Characters tab.
- Click the Symbol or Special character you want then click Insert to make it appear in the workbook.
- Click Close to exit the dialog box.
In Excel you can only use numbers, dates, and times in numeric calculations as Excel ignores symbols and special characters like blanks when doing its calculations. Excel’s fonts are based on Unicode which allows it to display characters from over 70 languages. To use a language other than English, attach an appropriate keyboard and use the Control Panel to set the Regional and Language options.
