E2 was the first cell in the zip code column

Assignment Help Computer Engineering

Reference no: EM133551280

When a list of addresses was imported, Excel deleted the leading zero in some of the zip code cells. Why would you use =TEXT(E2,"00000") if E2 was the first cell in the zip code column? It tells Excel you want five digits, including the first zero, and you can then drag down and type in the five-digit zip codes. It tells Excel you want five digits, including the first zero, and all the zip codes will display properly when you drag down. It tells Excel that you are working with zip codes, so Excel knows to allow the leading zero to appear.

Reference no: EM133551280

Questions Cloud

Create and maintain cyber security awareness program : Create and maintain Cyber Security Awareness Program a) Create a program to promote cyber security awareness. This Cyber Security Awareness Program

Preventing adverse childhood experiences : Select one of the ACE prevention strategies from Preventing Adverse Childhood Experiences

What is the user asking excel to do : what is the user asking Excel to do? Extract the five characters from the right in cell D2, which is the zip code. Extract the zip code and add it

What implications do you draw from your experience : What implications do you draw from your experience and the research to inform your future practice?

E2 was the first cell in the zip code column : Excel deleted the leading zero in some of the zip code cells. Why would you use =TEXT(E2,"00000") if E2 was the first cell in the zip code column

Create a function for each math operation : Create a function for each math operation (add, div, mult, sub). The application will run forever (while True), you will ask the user to continue or not

How the assessments can inform teaching and student learning : Describe two other types of assessment teachers can use and explain how these assessments can inform teaching and student learning.

Why is science crucial for understanding how people develo : Why is science crucial for understanding how people develo? An explain the 5 science methods?

Why is it difficult for hotels to provide security for guest : Why is it difficult for hotels to provide security for guests? There is a constant rotation of guests and they often have a false sense of security Criminals

User Account

All Pages