Leading the way in Microsoft Office Development

Excel

Step 1 - Inserting Symbols

Selecting (Insert > Symbol) will give you the complete character set for every font installed font on your PC.

This dialog box makes it very easy to insert special symbols and characters into cells.

It is important to remember that each font has a different set of special characters.

Step 2 - Symbols tab

Font - Select the font you want to use to display your character or symbol

Subset - Allows you to jump to specific areas in the character set:

Basic Latin, Latin-1 Supplement, Latin Extended-A, Latin Extended-B, Spacing Modifier Letters, Greek and Coptic, General Punctuation, Currency Symbols, Letterlike Symbols, Mathematical Operators, Geometric Shapes, Private Use Area

Character Code - Displays the code of the currently selected character. You can choose from displaying the code in either Unicode hex, ASCII decimal or ASCII hex.

Step 3 - Special Characters tab

This gives you access a number of commonly used special characters such as the trademark and copyright symbols.

These characters will be left aligned by default.

Not all the fonts support the Euro. Fonts that do support the Euro are Courier, Tahoma, Times and Arial.

List the common subsets

Step 4 - Things to Remember

You can enter the Euro symbol by pressing Alt + 0128 (on the numerical keypad)

If you are not using Excel 2002 but are using an earlier version you can use the Windows Character Map program to obtain similar functionality (charmap.exe).