Using the data to the left, in columns A to F:

Format the data properly.

Run the Macro named Week5Data!FormatImport, as we did in class, " 4 Running a Macro - 1". Refer to Lecture Slides for steps.

Show the result after running the macro.

Save your result.

Last Name	First Name	Appt Date	Appt Time	Service Name	Price
Beach	Sandor	2020-03-20	1900-01-00	Manicure, Spa	30.00
Clipper	Nelly	2020-02-27	1900-01-00	Manicure, Spa	30.00
Clauson	Felix	2020-03-06	1900-01-00	Manicure, Spa	30.00
James	Bernice	2020-03-08	1900-01-00	Manicure, Spa	30.00
Curlman	Jerry	2020-04-02	1900-01-00	Manicure, Spa	30.00
Kleeners	Senta	2020-04-08	1900-01-00	Manicure, Spa	30.00
James	Bernice	2020-03-29	1900-01-00	Manicure, Spa	30.00
James	Bernice	2020-04-02	1900-01-00	Manicure, Spa	30.00
James	Bernice	2020-03-26	1900-01-00	Manicure, Spa	30.00
James	Bernice	2020-05-07	1900-01-00	Manicure, Spa	30.00
James	Bernice	2020-05-28	1900-01-00	Manicure, Spa	30.00
Clauson	Felix	2020-02-17	1900-01-00	Hair Salon, Cut, Short	90.00
Kleeners	Senta	2020-02-29	1900-01-00	Hair Salon, Cut, Short	90.00
Clauson	Felix	2020-02-27	1900-01-00	Hair Salon, Cut, Short	90.00
Fetch	Ben	2020-02-28	1900-01-00	Hair Salon, Cut, Short	90.00
Klothe	Terry	2020-03-01	1900-01-00	Hair Salon, Cut, Short	90.00
Swanson	Caleb	2020-03-04	1900-01-00	Hair Salon, Cut, Short	90.00
Tatooit	Josh	2020-03-04	1900-01-00	Hair Salon, Cut, Short	90.00
Gregory	Edward	2020-03-07	1900-01-00	Hair Salon, Cut, Short	90.00