98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Entering phone numbers into a cell
Entering phone numbers into a cell
Resolved · Low Priority · Version 2007
Mon 22 Feb 2010, 17:02Delegate Sarah said...
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?
Wed 24 Feb 2010, 14:22Trainer Andrew said...
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Deleting a range of cells using the autofill handleFirstly, select the range of cells for which you would like to clear the contents. Then drag the autofill handle to the the top left corner of the selection whilst holding down the shift key. Your selected contents should then be deleted. |
