Excel+Data+cell+formatting+for+Tel+No.s+etc


 * Excel Data cell formatting for Tel No.s etc **

This tip is relevant to small companies etc rather than the home user.

Where you are entering into the respective cell phone numbers zip/Post codes etc. it can be a bind having to lace brackets hyphens etc in the correct places.

You can configure Excel to do this for you in order that you just type the numerical value in and Excel adds all the separations. For example in a phone number ( 01274) 309-516 you would just type 01274309516

First highlight the cells which you are going to or are using as the phone list. Go to :-
 * //Format > Cells//**

A window opens entitled **//Format Cells.//** Select the **//Number tab//** Almost at the bottom on the left-hand side you will see **//Special//** Click it This opens a window to the right which displays the selections which you can choose Obviously in this case you would click **//Phone Numbers.//** Then ensure that the Location is correct i.e. **//USA UK//** etc. Close and from now on your typing is much easier.
 * [[image:http://lindburghs-reference-library.wikispaces.com/site/embedthumbnail/placeholder?w=399&h=385 width="399" height="385"]] ||