Microsoft Office Tutorials and References
In Depth Information
Insert
SYMBOLS OR SPECIAL
CHARACTERS
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
quotation marks.
Symbols and special characters serve many uses in
Excel. Many financial applications, for example, call
2
A DD A S YMBOL
1
Click in the cell in which you
want to insert a symbol.
3
2
Click the Insert tab.
1
3
Click Symbol in the Text group.
l The Symbol dialog box appears.
4
Click here and then select a font.
5
Click the Symbol you want.
6
Click Insert.
l The character appears in the cell.
7
4
Click Close.
The Symbol dialog box closes.
5
6
7
10
Search JabSto ::




Custom Search