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

each year Lizzie's school purchases students agenda books, which are sold in the school store. This, the school purchased 350 books at a cost of $1,137.50 if th
Is 730.921 less than, greater than, or equal to 730,921?
find the product ad quotient of each pair numbers 24.6 and 1.2
43.586 rounded to the nearest hundredth
how does making a model help scientist observe?? HELPP PLEASEEE
What is 28.09 to the nearest tenths
if a set of numbers that both include both rational and irrational number is graphed on a number line what is the fewest number of distinct points that need to
(3x-4)∧2=8 how do i solve this
The first light bulb had a filament made of _____.
an airplane climbs at a rate of 66.8 feet per minute. It descends at twice the rate that it climbs. Assuming it descends at a constant rate, how many feet will