Use a formula in Microsoft Excel to fill [EEID \"0\" Padded to 7 characters] for

Question

Use a formula in Microsoft Excel to fill [EEID "0" Padded to 7 characters] for all records. What is this formula?

EEID SSN First Name Last name Date of Hire EEID "0" Padded to 7 characters Last 4 SSN Full Name Eligibility Date Medical Plan Name Was Plan Effective Before Eligible? 1 141658952 EXAMPLE RECORD 1/1/13 0000001 8952 EXAMPLE RECORD 4/1/13 EMPLOYEE + SPOUSE YES 215 852369147 ANOTHER EXAMPLE 4/1/13 0000215 9147 ANOTHER EXAMPLE 6/30/13 N/A N/A 6261 142689785 Sally Smith 2/9/10 89898 123456789 John Jones 1/19/11 222 234567891 Brian Whoknows 12/10/12 32323 345678912 Marrisa White 4/1/13 78956 456789123 Michael Whynot 5/15/13 12345 567891234 Dennis Anywho 6/14/13 45456 678945612 David Tyler 9/21/12 96267 987654321 Charles Roberts 9/19/12 515 654321987 Wendy Burger 6/4/12 85252 321654987 Jennifer Anything 8/2/12 95865 741852963 Judith Johnson 5/8/13

Explanation / Answer

Hi,

Below is the solution to your question:

Please follow the following steps:

1.Select the cell B2 and write the formula.

2.=REPT(0,7)

3.Now press ENTER on the keyboard.

4.This formula will add 7 0's to this EEID column.

5.Finally,copy the formula by pressing the key “CTRL+C” on the keyboard and paste in the range A3:A14 by pressing the key “CTRL+V”.

This will give you the required solution.

Hope that helps...HAPPY ANSWERING!!!!!!!!!!!

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.