Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

entering phone numbers into

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Entering phone numbers into a cell

Entering phone numbers into a cell

ResolvedVersion 2007

Sarah has attended:
Excel Intermediate course

Entering phone numbers into a cell

Is there a quick way to simply enter a phone number in the format of +44 20 ..., without having to manually enter and apostrpophe (') before each number, or when a copied number is moderated?

RE: Entering phone numbers into a cell

Hi Sarah

Thank you for your question. You could apply a text number format to the whole column used to store the numbers. To do this right click on the column letter and choose Format cells. On the number tab choose the Text category and click OK. Now try adding a phone number in that column and you should find Excel no longer re-formats the values.

Do let us know if you have any further quesitons.

Kind regards,
Andrew

Wed 3 Mar 2010: Automatically marked as resolved.

Excel tip:

Auto-insert the current time

In Microsoft Excel, to enter the current time into a cell, hold CTRL+SHIFT and press SEMICOLON.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.