Entering Phone #’s – What a Pain!

December 15, 2007

These days to make a call you have to dial the 10 digit number…which means dialing the area code as well as the local phone #.

Formating the # for each entry is a PAIN! For example to enter my phone number you would have to type “(613) 347-9893″. Thats a total of 14 keystrokes. Save yourself some time and format your phone # column as a phone #.

It’s Simple…

Select the whole column

Choose Format from the top menu bar

Select Cells and from the Drop-Down menu choose Special and select Phone Number

Now when you enter 6133479893 your entry will automatically be formatted to read (613) 347-9893… it saves a lot of time – believe me!

Hey… Wait a Minute…I’ve got an even better tip for inputting phone #’s and other information!

Call and I can Work with You!

Entry Filed under: MS Excel Tricks & Tips. .

Leave a Comment

Required

Required, hidden

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed


Categories

Recent Posts

Pages

 

December 2007
M T W T F S S
« Oct   Aug »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

Spam Blocked