Special Characters in Excel

Using a typical computer keyboard, you can directly type in approximately 94 different characters, 

such as letters and number other symbols like punctuation marks.



If you know the code number, you can enter that character any time by holding down the ALT key, and typing 

the 4-digit code number on the numeric keypad (the keys on the far right of your keyboard -- do not use the 

\"normal\" number keys above the letter keys).  Even though character code numbers are only three digits 

(between 0 and 255), you must type in the leading zeros to ensure that you get the proper character.   

For example, to enter in the British Pound sign, whose code is 163, hold down the ALT key, and type 0163 on the numeric keypad.  

Common Symbols And Codes



Euro            €    0128

Ellipsis        …    0133

Dagger          †    0134

Double Dagger   ‡    0135

Bullet          •    0149

Trademark       ™    0153

Cents           ¢    0162

Pounds          £    0163

Yen             ¥    0165

Copyright       ©    0169

Registered      ®    0174

Plus/Minus      ±    0177

Paragraph       ¶    0182

Degree          °    0176



Using Symbols In Formulas

If you need to use a special symbol in a worksheet formula, you can use the  function to return the 

character from its code number.  For example, suppose you want to add a copyright notice to your worksheet.

You could use the following formula: 



 =CHAR(169)




or



> Goto Insert -> Symbols and insert the symbols which you want.