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

convert 22000mg to cg
PLEAASE HELP I HAVE LITERALLY NO TIME LEFT I WILL GIVE BRAINLY SOON PLS HELP 2) the following table represents and inverse variation: x 2 l 4 l 6 l l --------
If you were to measure a straight line from New York to Hong Kong it would measure 12.6 cm. If the scale of the map says that 3000 miles are 3.2 cm, what is the
DIRECTIONS: Label the nouns/pronouns as S (subject), OP (object of a preposition), DO (direct object), IO (indirect object), PN (predicate nominative). Label an
10/3 is equal to 3 1/3
Please help! I can give brainliest also! Thank you!
120 Jos David has saved $9.59. His sister has $3.24 less. How much does she have?
Find the slope of the line that passes through each pair of points. a. A(1,3), B(4,7) b. C(3,5), D(2,6) does anyone know this?
Vanessa has $60 to spend on rides at the state fair. Each ride cost $4
Which One is the Correct answer? 1,2,3, or 4?Please hurry...