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