kairif70 kairif70
  • 15-01-2020
  • Computers and Technology
contestada

how should excel categorize telephone numbers as text numbers or dates and times why

Respuesta :

colocho08
colocho08 colocho08
  • 21-01-2020

Answer:

text numbers

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 = ################

Answer Link

Otras preguntas

In what ways, that are still identifiable today, did the Roaring Twenties influence the culture of America? Support your answer with evidence and examples.
Rad 18x^5y + Rad 32xy^3 - Rad 128xy
What is the measure of RIA ?
Unlike other states, in texas ___________ can introduce bills in the texas legislature.
The coordinate plane below represents a city. Points A through F are schools in the city. Part A: Using the graph above, create a system of inequalities that on
Why does smithfield and other slaughterhouses only hire the poor, minorities, and immigrants?
Now consider the reaction a+2b⇌c for which in the initial mixture qc=[c][a][b]2=387 is the reaction at equilibrium? if not, in which direction will it proceed t
The anatomic structure of the ear that is snail-shaped and contains the organ of hearing is the
how far away is spain from america ?
Why must a company estimate the amount of factory overhead assigned to individual jobs or job lots?