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