How should excel categories telephone numbers: as txt, numbers, or dates and time? Why?

Answer :

It should read it as a number. Since a phone number is longer than a date and does not have any alphabetical characters it will be read as a number.