Entering Phone #’s – What a Pain!   Leave a comment

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!

Posted December 15, 2007 by pasadmin in MS Excel Tricks & Tips

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.