Excel (By S. Van Eenoo)

Alt-Code for special characters

Function syntax

Value

=char(153)

™

=char(169)

©

=char(174)
=char(128)

®
€

Tip: the function char works with any number between 1 and 254.
Tip: Instead of using the function Char, try pressing and holding Alt and type 0153. Use the same number as you would with the function Char, but add a leading zero.

Custom Number formats

Use custom number formats to create you own code 

To add leading zeros.

To make the input of phone numbers easier

 To make the input account numbers easier

To add text to values, and still be able to calculate with them

…

Please find enclosed a word document (7 pages) whichs explains custom cumber formats, and an Excel file with some examples. 
Custom [...]