Creating and editing custom format codes on Excel.

Create a custom format code to produce formatted cell content that match Figure 5-73b.

worksheet should appear as shown in Figure just the formatting code applied to the entries 6. If r 10- 7. Sav ins Extend 5-1 Custom Format Codes Excel et Page Layout Formula DatsReview View Tell ewhat you want to do Da Copy Fi in Custom Format Codes 3035559876 PN-49831 207.90 752 2017 Ex Crea your 3 10-digit phone number 4 6-digit number with text 5 dollars and cents 6 negative number with text and color 7 4-digit year with text 8 day followed by date 9 text with text 10 negative % with parenthesis 11 %and text 12 hours and minutes 13 military time with text Extend 5- Custom Farmal Codes Cople Wed 8/9/2017H Tell e what Con Instr tal st Inert Page LayouFormla DatsRevw cut Wrap Tet (40%) 75.00% Copy r | Paste Format Panter 3:25:00 PM ,G |] Custom Format Codes Perf X v' 600 hours | Custom Formats Custom Format Codes Ready (a) Original Data 2. 3 10-digit phone number 4 6-digit number with text 5 dollars and cents 6 negative number with text and color 7 4-digit year with text a day followed by date 9 text with text 10 negative % with parenthesis 11 % and text 12 hours and minutes 13 military time with text 303.555.9876 PN-049831 207 dollars and.90 cents 752.00 loss Current Year 2017 Wednesday-8/9/2017 The month is June (-80.4%) 75% complete 5 hours and 25 minutes 0600 hours 3. 4. Custom Fonmats (b) Data with Custom Format codes worksheet should appear as shown in Figure just the formatting code applied to the entries 6. If r 10- 7. Sav ins Extend 5-1 Custom Format Codes Excel et Page Layout Formula DatsReview View Tell ewhat you want to do Da Copy Fi in Custom Format Codes 3035559876 PN-49831 207.90 752 2017 Ex Crea your 3 10-digit phone number 4 6-digit number with text 5 dollars and cents 6 negative number with text and color 7 4-digit year with text 8 day followed by date 9 text with text 10 negative % with parenthesis 11 %and text 12 hours and minutes 13 military time with text Extend 5- Custom Farmal Codes Cople Wed 8/9/2017H Tell e what Con Instr tal st Inert Page LayouFormla DatsRevw cut Wrap Tet (40%) 75.00% Copy r | Paste Format Panter 3:25:00 PM ,G |] Custom Format Codes Perf X v' 600 hours | Custom Formats Custom Format Codes Ready (a) Original Data 2. 3 10-digit phone number 4 6-digit number with text 5 dollars and cents 6 negative number with text and color 7 4-digit year with text a day followed by date 9 text with text 10 negative % with parenthesis 11 % and text 12 hours and minutes 13 military time with text 303.555.9876 PN-049831 207 dollars and.90 cents 752.00 loss Current Year 2017 Wednesday-8/9/2017 The month is June (-80.4%) 75% complete 5 hours and 25 minutes 0600 hours 3. 4. Custom Fonmats (b) Data with Custom Format codes