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

Michael Sohnen asked Jan 25, 2023

155,547 views

20 votes

Michael Sohnen asked Jan 25, 2023

2.5k points

Your comment on this question:

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Email me at this address if my answer is selected or commented on:Email me if my answer is selected or commented on

Privacy: Your email address will only be used for sending these notifications.

20 votes

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.

SvdSinner answered Jan 29, 2023

2.8k points

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

1.6m questions

2.0m answers