Microsoft Office Tutorials and References
In Depth Information
SYMBOLS OR SPECIAL
In Excel, you are not restricted to the standard
numerals, letters, and punctuation marks on your
keyboard. You can also select from hundreds of special
characters, such as foreign letters and currency
characters such as the Euro (
for currency symbols. Symbols and special characters
are useful in column and row heads as part of the
text describing column and row content, for example,
Net sales in
Using symbols and special characters in the same cell
with a value such as a number, date, or time usually
prevents the value from being used in a formula. If
you need to use a symbol in a cell used in a formula,
use a number format. If you need to create a custom
number format, see Task #98.
). Each font has a
different set of special characters. A smaller set of
standard characters, called symbols, is always
available as well; they include dashes, hyphens, and
Symbols and special characters serve many uses in
Excel. Many financial applications, for example, call
A DD A S YMBOL
Click in the cell in which you
want to insert a symbol.
Click the Insert tab.
Click Symbol in the Text group.
l The Symbol dialog box appears.
Click here and then select a font.
Click the Symbol you want.
l The character appears in the cell.
The Symbol dialog box closes.