182k views
3 votes
How should excel categorize telephone numbers as text numbers or dates and times why

1 Answer

1 vote

Answer:

text numbers

Step-by-step explanation:

The best option, in this case, is to use text numbers because if we use more than sixteen digits, Excel will round any numbers that follow the 15th digit down to zero, Excel has a maximum of precision of fifteen digits, this can help us with credit card numbers or telephone numbers.

For example:

text format = 45564983874897659

number format = 45564983874897600

date format = ################

User Rahbee Alvee
by
4.7k points