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. .
Trackback this post | Subscribe to the comments via RSS Feed